Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental data aggregation?
- 3 Answers
- 6933 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 |
Explain the aggregator transformation?
Explian the connected and unconnected lookup transformation
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What are partitions in informatica and which one is used for better performance?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
how can u load the data in time dimension?
How to extract sap data using informatica? What is abap? What are idocs?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to add source flat file header into target file?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
how to insert header after each group.
Teradata 
