Answer Posted / sehaj
Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between router and filter?
Explain incremental aggregation in informatica
Sequence generator, when you move from develoment to production how will you reset
Explain the aggregator transformation?
What is a mapplet/worklet in informatica?
can we override a native sql query within informatica? Where do we do it?
What is the function of aggregator transformation?
What is the format of informatica objects in a repository?
How to join three sources using joiner? Explain though mapping flow.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is a pre-defined event and user-defined event?
What's the layout of parameter file (what does a parameter file contain?)?
What are the tasks that source qualifier perform?
what is mean by complex business rule ?
