![]() Related Questions Latest Answer : Hierarchical level of datawarehousing is nothing but the concept of generalization and specialization.As we move up the hierarchy the data is more generalized for ex : the location where STATE is more genarilized for of locationAs we move down the hierarchy ... 1) Differences between DSS and OLTP.2) Explain Grouped cross tab.3) Define Surrogate key.4) What is IQD file.5) Expalin Reference cursor. Read Answers (3) | Asked by : vasanth kishore Latest Answer : Surrogate keys are the system generated keys and used to eliminate the redundancy in the primary keys. So they are always integer numbers. ... Read Answers (5) | Asked by : pepsi Latest Answer : The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk). Cheers,Ravi Kumar Garre ... Read Answers (1) | Asked by : keerthi “A dimension table is wide but the fact table is deep” Explain the statement in your own words. Read Answers (4) | Asked by : Saba Explain multidimensional data models and how they are integrated with the architecture you have already designed Explain why database design is important? Is data, transient or periodic in data mart? Explain Latest Answer : Data marts are part of OLAP system. Data in datamarts cannot be trasient. Data will be updated in datamarts on a periodic or daily basis depending on the design of the data warehouse.-Ashish ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||