Answer Posted / radhakrishnan vaithilingam
The staging area is used to travel the data between Source
sytem to Data wareshoue or datamart.
it should be important when we are extracting more than one
source sytem.
The staging will help us to do the cleansing and converting
the data to understaing the business team.
Bridge between source to data warehouse or Data mart.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain hybrid slowly changing dimension?
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?
Which component has onread method and what it is used for?
What is core dimension?
How are the dimension tables designed?
How can you set the session management?
Explain what is data validation strategies for data mart validation after loading process?
Is there any rownum object from which we can do this?
What is a functional dependency f said to be minimal?
Explain why should you put your data warehouse on a different system than your oltp system?
I need a good brd and uc template?
What is the differences between star and snowflake schemas?
Can decision tree be implemented using SQL?
Explain the difference between data ware house & data mart?
What is the difference between snowflake and star schema?