Define Incremental Aggregation?

Answers were Sorted based on User's Feedback



Define Incremental Aggregation?..

Answer / abhinaw prakash

When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes incrementally and you can
capture changes, you can configure the session to process
those changes. This allows the Integration Service to update
the target incrementally, rather than forcing it to process
the entire source and recalculate the same data each time
you run the session.

For example, you might have a session using a source that
receives new data every day. You can capture those
incremental changes because you have added a filter
condition to the mapping that removes pre-existing data from
the flow of data. You then enable incremental aggregation.

When the session runs with incremental aggregation enabled
for the first time on March 1, you use the entire source.
This allows the Integration Service to read and store the
necessary aggregate data. On March 2, when you run the
session again, you filter out all the records except those
time-stamped March 2. The Integration Service then processes
the new data and updates the target accordingly.

Is This Answer Correct ?    8 Yes 0 No

Define Incremental Aggregation?..

Answer / kunkala.ramakrishna

IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES

YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  


What is the surrogate key?

0 Answers  


What is the need of building a data warehouse?

2 Answers  


What is power center repository?

1 Answers  


How to extract original records at one target & Duplicate records at one target?

12 Answers  


write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,


Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


what are cost based and rule based approaches and what is the difference?

1 Answers  


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


what type of problem you faced insales project or insurance project

1 Answers   Sony,


Categories