Answer Posted / 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 |
Post New Answer View All Answers
What is InformaticaPowerCenter?
What is the sequence generator transformation in informatica?
What is union transformation in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In how many ways we can create ports?
Could you explain what is enterprise data warehouse?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What does refresh system mean, and what are its distinctive choice?
Can anyone tell me the new features in Informatica 9 Version?
What is domain and gateway node?
What happens when a session fails and you click on recover?
Where is metadata stored?
Whats there in global repository
generate date / time dimension in informatica
