Interested to Buy Any Domain ? << Click Here >> for more details...
Define Incremental Aggregation?
- 2 Answers
- 6977 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is enterprise data warehousing?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
How to delete duplicate row using informatica?
What are the new features of the server manager in the informatica 5.0?
how we can do session partition in informatica any one explain me clearly? thanks advance.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
To provide support for Mainframes source data,which files r used as a COBOL files
Teradata 
