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
tell me the rules and responsblites in our project(my project is development)
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What could be the possible resons of locks by user?
What are pre and post-session shell commands?
What is the maplet?
What is difference between a gateway node and worker node?
how tokens will generate?
What is decode in static cache?
Define joiner transformation?
wat are deployement groups in informatica, how it will be used for developers
While migrating the data from one environment to another environment how would you manage the connections?
What are ETL Tools?
What are some examples of informatica etl programs?
What is enterprise data warehousing?
How to implement security measures using repository manager?
