Un-Answered Questions { Data Warehouse General }

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

615


Why fact table is in a normal form?

567


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

561


How to load the time dimension?

556


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

539


Where do we use semi and non additive facts?

598


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

546


Explain the main differences between star and snowflake schema?

552


Explain me what are data marts?

608


Explain what is type 2 version dimension?

613


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

509


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

675


How are the dimension tables designed?

575


What is cubes?

633


What is analytical or analytic mean?

625