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

difference between shortcut and reusable transformation?

2 Answers  


What is the difference Between Mapping parameter and variable

3 Answers   Accenture,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  


In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  


.prm wirh repalce .txt is possible?

2 Answers  


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


What is transformation?

0 Answers  


Categories