What is the use of incremental aggregation?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964


what is diff b/t sorter t/r and agg have the option sorter property...

1737


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1399


What is joiner transformation in informatica?

623


Is there any way to read the ms excel datas directly into informatica?

546






Partition, what happens if the specified key range is shorter and longer

2028


What is meant by a domain?

623


How can you differentiate between powercenter and power map?

620


What is repository manager?

532


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328


What is the cumulative sum and moving sum?

752


Why filter transformation is an active one?

560


What all join we can perform in LOOKUP transformation?

559


What is the different lookup cache(s)?

610


What is intricate mapping?

586