We have moved to www.dataGenX.net, Keep Learning with us.
Showing posts with label granularity. Show all posts
Showing posts with label granularity. Show all posts

Tuesday, September 24, 2013

Interview Questions : DataWareHouse - Part 2


For more : Visit HERE




What is real time data-warehousing?

Data warehousing captures business activity data. Real-time data warehousing captures business activity data as it occurs. As soon as the business activity is complete and there is data about it, the completed activity data flows into the data warehouse and becomes available instantly.


What are conformed dimensions?
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined. They are common to the cubes.


What is conformed fact?
Conformed dimensions are the dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly.