What is incremental aggregation and how it is done?

Answer Posted / ankit kansal

Incremental Aggregation ->

Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.

It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1549


what is the -ve test case in your project.

1848


What is exclusive and normal mode for repository services?

709


Can you generate sequence numbers without using the sequence generator transformation?

595


What are batches?

617






What is expression transformation?

629


Where can we find the throughput option in informatica?

600


Performance tuning( what you did in performance tuning)

1483


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2274


What is source qualifier transformation in informatica?

571


Whats there in global repository

1262


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1576


What are the different types of repositories created using informatica?

653


Which means the first record should come as last record and last record should come as first record and load into the target file?

608


list out all the transformations which use cache?

685