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 sessions and how many types of sessions are there?
Explain transaction control transformation in informatica
Explain pmcmd command usage in informatica
What is the meaning of up gradation of repository?
How many transformations can be used in mapplets.
What does role playing dimension mean?
What is domain in terms of informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to load the data from people soft hrm to people soft erm using informatica?
Explain what is informatica metadata and where is it stored?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How we can create indexes after completing the load process?
In informatics server which files are created during the session rums?
