what is incremental aggregation ,with example?

Answers were Sorted based on User's Feedback



what is incremental aggregation ,with example?..

Answer / sehaj

Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.

Is This Answer Correct ?    2 Yes 0 No

what is incremental aggregation ,with example?..

Answer / naveen kumar

Before doing incremental aggregation u need to know incremental load, source data should be loaded incrementally, place a aggregator transformation group the ports on your requirement,like sales date then write your aggregate functions like max, min, sum, avg etc.. then check the property of incremental aggregation in session make sure the target table should have a primary key if it is relational then run the workflow... then u get the inital values pass a new record to the source and run the workflow.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,


explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,


Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,


How many ways you create ports?

1 Answers  


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


What are the types of presistent cache in look up tr.

0 Answers   IBM,


What is a node in Informatica?

0 Answers  


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  


Write the unconnected lookup syntax?

0 Answers  


What is an expression transformation?

0 Answers  


Categories