Answer Posted / reetesh jain
Yah its right.
Want to add some point in it.
Basically Staging Area is the mirror image of the warehouse.
And during this stage creation of FACT & DIMENSION table
comes into the picture.
Please let me know if any point is missing.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to reduce warnings?
what are the all possible features supported modify stage?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are the different types of data warehouses?
Why is business intelligence (bi) important in data warehousing?
what are the others of "bad files" and "discard files" when using sql*loader?
What does level of granularity of a fact table signify?
What is the difference between filter and lookup transformation?
What is metadata in context of a datawarehouse?
Explain what are the different types of data warehousing?
How can you communicate with web server (apache or iis) from coldfusion?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is data warehosuing hierarchy?
What is the definition of cube in datawarehousing?
What are the advantages of query studio compared to report studio?
