how can we perform incremental aggregation?explain with
example?

Answer Posted / appireddy

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain lookup transformation in informatica

650


What are mapplets?

826


explain abt ur project architecture?

1765


What are the performance considerations when working with aggregator transformation?

678


How to do unit testing in informatica? How to load data in informatica ?

655






Explain the code page compatibility?

644


Explain the difference between a data warehouse and a data mart?

600


Explain direct and indirect flat file loading (source file type) - informatica

837


How to load last n records of file into target table - informatica

600


Explain what is informatica metadata and where is it stored?

615


Global and Local shortcuts. Advantages.

1472


How can we use batches?

606


How to load a Dimension ? and how to load a fact table?

957


Write the program through which the records can be updated?

520


What is union transformation?

575