Answer Posted / anju
staging area is used to integrate data from various
heterogenous sources. the advantage is recoverability. ie
if load session fails we can get data from staging area.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What do mean by local and global repository?
Is it possible to revert a global repository to local one and why?
What is the need for an etl tool?
What do you mean by channel change?
What are the components of Informatica? And what is the purpose of each?
What are the different ways to implement parallel processing in informatica?
Explain sessions. Explain how batches are used to combine executions?
What are the reusable transformations?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can we use batches?
What is the fact table?
What are active transformations.
Differentiate between source qualifier and filter transformation?
What is the cumulative sum and moving sum?
what is the size of u r source(like file or table)?