Interested to Buy Any Domain ? << Click Here >> for more details...
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 a connected transformation?
How do you handle two sessions in Informatica
Explain target update override in informatica
What is a rank transform?
Why update strategy and union transformations are active?
What is DR strategy for Informatica project?
What is domain and gateway node?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is pmcmd command?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a shortcut and copy in Informatica and how two are different with each other?
