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
What is parallel processing in informatica?
Mention few advantages of router transformation over filter transformation.
Enlist some properties of sessions.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between source qualifier and filter transformation?
How do you load only null records into target? Explain through mapping flow.
During the running session, output files are created by informatica server. Enlist few of them.
Why is sorter an active transformation?
How many transformations can be used in mapplets.
difference between repository database and repository service?
How to handle decimal places while importing a flatfile into informatica?
What are the main issues while working with flat files as source and as targets ?
Differences between connected and unconnected lookup?
what is the -ve test case in your project.
How can we delete duplicate rows from flat files?