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
What is a relationship?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What are the stages of datawarehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to pivot data using informatica when you have variable amount of pivot rows?
What is a Decision Tree Algorithm?
What are snapshots? What are materialized views & where do we use them?
What is aggregate fact table?
What is Operational Data Store?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain what are the various methods of getting incremental records or delta records from the source systems?
How are models actually derived?
What is a hash cluster?
Define data warehouse?
How to test report in reportnet?