Un-Answered Questions { Data Warehouse General }

Explain what is data validation strategies for data mart validation after loading process?

605


Why fact table is in a normal form?

563


Explain the main difference between inmon and kimball philosophies of data warehousing?

554


How to load the time dimension?

550


What are the advantages of raid 1, 1/0, and

533


Where do we use semi and non additive facts?

590


In microstrategy, how can we direct the sql generated to use a specifc table?

534


Explain the main differences between star and snowflake schema?

546


Explain me what are data marts?

596


Explain what is type 2 version dimension?

607


Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

507


Explain what is the difference between a primary and secondary actor in use case modeling?

665


How are the dimension tables designed?

567


What is cubes?

623


What is analytical or analytic mean?

620