Latest Answer: A rapidly changing dimension is a result of poor decisions during the requirements analysis and data modeling stages of the Data Warehousing project. If the data in the dimension table is changing a lot, it is a hint that the design should be revisited. ...
Latest Answer: It is a system generated sequence number, an artificial key used in maintaining history.It comes while handling slowly changing dimensions ...
Latest Answer: Degenerated Dimension is a dimension key without corresponding dimension. Example: In the PointOfSale Transaction Fact table, we have: Date Key (FK), Product Key (FK), Store ...
Latest Answer: 1.Understand the bussiness requirements.2.Once the business requirements are clear then Identify the Grains(Levels).3.Grains are defined ,design the Dimensional tables with the Lower level Grains.4.Once the Dimensions are designed,design the Fact table ...
Latest Answer: Architecture 1:Source=>Staging=>DWHArchitecture 2:Source=>Staging=>Datamarts ...
Latest Answer: Data Mining is used for the estimation of future. For example, if we take a company/business organization, by using the concept of Data Mining, we can predict the future of business interms of Revenue (or) Employees (or) Cutomers (or) Orders ...
Latest Answer: View is a logical reference to a database table. But Meterial View is actual table and we can refresh data in time intervels. If you made any change in database table that change will effect into view but not meterialize view.. ...
Latest Answer: RalfKimball: he follows bottum-up approach i.e., first create individual Data Marts from the existing sources and then create Data Warehouse.BillImmon: he follows top-down approach i.e., first create Data Warehouse from the existing ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
