Answer Posted / sai suresh
Staging area is a where data transformaions takes place. It
is temparly storage area . Transformations like "DATA
SCRUBBING, DATA CLEANSING,DATA AGGREGATION,DATA MERGING"
The above transformations are takes place in the staging
area, in staging area data transformed from one format to
required business format then it will load into the target.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is session task and command task?
What are the advantages of using informatica as an etl tool over teradata?
what is INFORMATICA TESTING process
What is rank transformation?
Can we create multiple integration service on single repository?
What are the tasks that source qualifier perform?
Explain transaction control transformation in informatica
How can we use batches?
What is a sorter transformation?
explain abt ur project architecture?
What is the function of look up transformation?
Explain the difference between mapping parameter and mapping variable?
What are session parameters ? How do you set them?