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
Explain lookup transformation in informatica
What are mapplets?
explain abt ur project architecture?
What are the performance considerations when working with aggregator transformation?
How to do unit testing in informatica? How to load data in informatica ?
Explain the code page compatibility?
Explain the difference between a data warehouse and a data mart?
Explain direct and indirect flat file loading (source file type) - informatica
How to load last n records of file into target table - informatica
Explain what is informatica metadata and where is it stored?
Global and Local shortcuts. Advantages.
How can we use batches?
How to load a Dimension ? and how to load a fact table?
Write the program through which the records can be updated?
What is union transformation?