Answer Posted / pradip sahoo
A staging area is where data is processed before entering
into the data warehouse. You need to clean and process the
data before putting it into a warehouse. Cleansing means
removing extra spaces, deleting null values from primary
key columns, etc.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are Non-additive facts?
What is metadata in context of a datawarehouse and how it is important?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a full backup?
Explain functional dependency?
What are various warehousing tools?
How can we load the time dimension?
What is type 2 version dimension?
How can you set the client management?
Explain what are components of report studio?
what is difference between drill & scope of analysis?
What are the differences between star and snowflake schema?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is cost benefit analysis (cba)?
Explain the difference between filter and conditin?