what is incremental aggregation ,with example?

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


Please Help Members By Posting Answers For Below Questions

What is dimensional table?

619


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

632


What are the different transaction levels available in transaction control transformation?

673


server hot-ws270 is connect to Repository B. What does it mean?

1855


What is a pre-defined event and user-defined event?

577






What is a joiner transformation and why it is an active one?

578


Explain the difference between mapping parameter and mapping variable?

603


How are indexes created after completing the load process?

987


Explain in detail about scd type 1 through mapping.

587


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1601


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5788


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1618


Explain sessions. Explain how batches are used to combine executions?

592


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

673


What is the benefit of session partitioning?

591