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
How union transformation is used?
How can you differentiate between powercenter and power map?
Slowly changing dimensions, types and where will you use them
How do you convert single row from source into three rows into target?
In warehouses how many schemas are there?
What is a joiner transformation and why it is an active one?
What is the format of informatica objects in a repository?
What are the different components of powercenter?
design of staging area?
How to do unit testing in informatica? How to load data in informatica ?
What is a predefined event?
What is sorter transformation?
What is transformation?
Is there any way to read the ms excel datas directly into informatica?
What do you mean incremental aggregation?