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
Explain pushdown optimization $pushdownconfig parameter - informatica
What do you mean incremental aggregation?
What is Cognos script editor?
Where can we find the throughput option in informatica?
What is the cumulative sum and moving sum?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to configure mapping in informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Which version configuration tool used in ur project?
What are the differences between joiner transformation and source qualifier transformation?
What are the tuning techniques you applied during your last project
What is domain in terms of informatica?
How you can differentiate between connected lookup and unconnected lookup?
How do you load unique records into one target table and duplicate records into a different target table?
