| |||||
|
Data Warehousing Interview Questions and Answers Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 (Continued from previous part...) Data Warehousing Concepts Interview Questions and Answers (3) Is OLAP databases are called decision support system ??? true/false? True explain in detail about type 1, type 2(SCD), type 3 ?
Type-1
What is snapshot? You can disconnect the report from the catalog to which it is attached by saving the report with a snapshot of the data. However, you must reconnect to the catalog if you want to refresh the data. What is the difference between datawarehouse and BI? Simply speaking, BI is the capability of analyzing the data of a datawarehouse in advantage of that business. A BI tool analyzes the data of a datawarehouse and to come into some business decision depending on the result of the analysis. What are non-additive facts in detail?
A fact may be measure, metric or a dollar value. Measure and metric are non additive facts.
|
||||