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
How to implement security measures using repository manager?
What do you mean by filter transformation?
what is mean by complex business rule ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is flashback table ? Advance thanks
Explain the scenario which compels informatica server to reject files?
Define update strategy?
is it possible to index the data in cache of lkp transformation ?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is Cognos script editor?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to update a particular record in target with out running whole workflow?
Different qualification between a related rotate toward the sky and isolates look upward?
What are some examples of informatica etl programs?