Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental data aggregation?
- 3 Answers
- 7069 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 |
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
What is confirmed dimension and fact?
How to load last 10 records of flat file in to the target?
How can you increase the performance in joiner transformation?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
how to call lookup qualifer in unconnected look;up
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
How will you update the first four rows and insert next four rows in a mapping?
what is dimension table?
can we override a native sql query within informatica? Where do we do it?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Teradata 
