what is incremental data aggregation?
- 3 Answers
- 5835 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Incremental aggregation means applying only the captured
changes in the source to aggregate calculations in a session.
When the source changes only incrementally and if we can
capture those changes,then we can configure the session to
process only those changes.This allows informatica server to
update target table incrementally,rather than forcing it to
process the entire source and recalculate the same
calculations each time you run the session.By doing this
obviously the session performance increases.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / shruthi
When the aggregator transformtaion executes all the output
data will get stored in the temporary location called
aggregator cache. when the next time the mapping runs the
aggreagator transformation runs for the new records loaded
after the first run. These output values will gets
incremented with the values in the aggregator cache. Thia
is called incremental aggregation. By this way we can
improve performance...
Correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lokesh y g
suppose yesterday 100 got inserted into target,today 50
records inserted and 25 records got updateted ,rather then
pulling all records, using incremental logic we can pull
the data only updated records and inserted records using
setmax variable ........
| Is This Answer Correct ? | 0 Yes | 0 No |
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
why we need informatica
How can you join two tables without any common column present in them?
What is critical mapping?
Plz..let me know differences between Informatica 7.1 and 8.1?
What are the types of metadata that stores in repository?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What are some examples of informatica etl programs?
What are limitations of joiner transformation?
What are reusable transformations in how many ways we can create them?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
How can you run a session without using server manager?
Teradata 
