Can a dimension table contain numeric values?
how much memory space occupied real time project (roughly)?
What are Data Marts?
Tell me what is degree of a relation?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is scd1 , scd2 , scd3?
What are vaious etl tools in the market?
Where the applications and where ware house management system is used?
Which one among Star and snowflake schemas will occupy more space?
What are the different types of join operations?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?