Define Incremental Aggregation?
Answers were Sorted based on User's Feedback
Answer / 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 |
IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES
YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES
Is This Answer Correct ? | 2 Yes | 0 No |
explain about unit testing? in real time?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
what are the Methods For Creating Reusable Transformations?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What is difference macros and prompts?
What is Code Page Compatibility?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Performance tuning in UNIX for informatica mappings?
What is a node in Informatica?