Latest Answer: Star Schema: A single fact table associated to N dimension tables. This schema is denormalised and hence has good performance as this involves a simple join rather than a complex query.Snowflake schema:A star schema in which dimensions are further ...
What is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?
Latest Answer: ODS: this is operational data stores, which means the real time transactional databases. In data warehouse, we extract the data from ODS, transform in the stagging area and load into the target data warehouse.I think, earlier comments on the ODS is little ...
Latest Answer: I think the comments made earlier are not specific.We dont required any seperate space for data mart and data where house unless until those marts are too big or client required.We can maintain both in a same schema. ...
How data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.
Latest Answer: It is nothing but purifying data , the extract process always exposes the data qulaity issues that have been bured within the operational source system. Since the data qulaity significantly impacts data warehouse credibility , you need to address these ...
Latest Answer: dataware house is a container to store the historical datawhere as dataware hosuning is a process or technique to analyze tha data in the ware house ...
Latest Answer: Datawarehousing depends on the surrogate key not primary key, for suppose if u r taking the product price it will change over the time, but product no. will not change but price will change over the time to maintain the full hystorical data ...
For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fact Tables
Latest Answer: Degenerated Dimension is achieved through a gradual modeling approach
following Dimensional Modeling standards. Let's take example of a Star Schema
representing Sales Invoices. The FACT would have the "Invoiced Amount" as
primary measure. ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
