Latest Answer: Static cache - It doesn't reflect changes once data is cached is known as static cache.
Dynamic cache - It reflect to changes at the time of running the session if any updates happen in source data. ...
Latest Answer: Yes, It may contain numeric values. If customer_dim table has attributes like cust_id, cust_name, contact_no, salary and so on. Here cust_id, contact_no, salary are numerics only. ...
Latest Answer: Hybrid SCDs are combination of both SCD 2 and SCD 3.Whatever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT. There is new column added to provide the previous record info (generally ...
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: Best example is "Invoice Number","bill number","PO Number", these all are degenerated dimensions in the Transaction Tables, they can be maintained in the fact table itself instead of crating seperate dimensions for ...
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: Linked CubeA cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. This arrangement avoids the more costly alternative ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
