Employ of incremental aggregation

Question

Write down the employ of incremental aggregation?

Answer 1

It’s a session option. When informatica server executes incremental aggregation. It passes latest source data by the mapping and uses historical cache data to execute new aggregation calculations’ incrementally.

When using incremental aggregation, we apply captured alters in source to aggregate computations in session. If the source alters incrementally and we can capture alters, we can configure session to process those alters. This provides the Integration Service to upgrade the target incrementally, rather than forcing it to process the whole recalculate and source the similar data each time you run session.

For illustration, we may have a session using a source which obtains new data all day. We can capture those incremental alters since we have added a filter situation to the mapping which removes pre existing data from flow of data. We then facilitate incremental aggregation.

When the session executes with incremental aggregation enabled for first time on March 1, we employ the whole source. This provides the Integration Service to store and read the essential aggregate data. On March 2, when we execute the session again, we filter out all the records apart from those time-stamped March 2. The Integration Service then processes new data and upgrades the target accordingly.

Consider using incremental aggregation in subsequent situation which are illustrated below:

We can capture latest source data. Employ incremental aggregation when we can capture latest source data each time we run the session. Employ a Stored Procedure or Filter transformation to process latest data.

Incremental alters don’t significantly alter target. Employ incremental aggregation when alters don’t significantly alter target. If processing the incrementally changed source alters more than half the existing target, the session might not benefit from the using incremental aggregation. In this case, drop table and recreate the target with entire source data.