Answer Posted / shruthi
When the aggregator transformtaion executes all the output
data will get stored in the temporary location called
aggregator cache. when the next time the mapping runs the
aggreagator transformation runs for the new records loaded
after the first run. These output values will gets
incremented with the values in the aggregator cache. Thia
is called incremental aggregation. By this way we can
improve performance...
Correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
Is there any target staging area in informatica not staging area
Briefly define a session task?
Explain what are the different types of transformation available in informatica.
What are the issues you have faced in your project? How did you overcome those issues?
How to differentiate between the active and passive transformations?
Briefly explain the aggregator transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the uses of etl tools?
How to load data in informatica ?
write a query to retrieve the latest records from the table sorted by version(scd)
What is olap (on-line analytical processing?
can anyone suggest best free Talend data integration training online
What are the advantages of using informatica as an etl tool over teradata?
Name at least 5 different types of transformations used in mapping design and state the use of each.?