What is the use of incremental aggregation?

Question Posted / guest

2 Answers
9022 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the use of incremental aggregation?..

in incremental aggregation only the captured changes will be
considered for aggregate calculation i.e. when new data will
be inserted for calcutation , informatica power center
server will not start the processing from the begining .

Is This Answer Correct ?

5 Yes

0 No

What is the use of incremental aggregation?..

Answer / lokendra

The first time you run an incremental aggregation session,
the PowerCenter Server processes the entire source. At the
end of the session, the PowerCenter Server stores aggregate
data from that session run in two files, the index file and
the data file. The PowerCenter Server creates the files in
a local directory.

Each subsequent time you run the session with incremental
aggregation, you use only the incremental source changes in
the session.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer