Explain Process flow in data warehouse??
Answer Posted / parvar
1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is there any difference in testing database and data ware housing?
What is the difference between data warehouse and operational systems?
What are fact, dimension, and measure?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Why null values are mapped as 0 in fact tables?
Explain what are the modules in power mart?
How can you communicate with web server (apache or iis) from coldfusion?
Explain why dimenstion tables are denormalized in nature?
Can you pass sql queries in filter transformation?
Explain what are the different methods of loading dimension tables?
What is the difference between star and snowflake schemas?
What are data modeling and data mining? Where it will be used?
What is operational data store (ods)?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to load the time dimension?