Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental data aggregation?
- 3 Answers
- 7083 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 |
Can we update the data in flat file using update strategy?
What is a repository? And how to add it in an informatica client?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
How many number of sessions that u can create in a batch?
what is confirmed dimension?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Describe expression transformation?
What is main use of mapplet?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Teradata 
