Answer Posted / swetha
When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a predefined event?
Explain the different lookup methods used in informatica?
Why do you use Mapping Parameter and mapping variable?
my source is junk data how will u remove that junk data by using unix please any one replay me
What the difference is between a database, a data warehouse and a data mart?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is parallel processing in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How do you update the records with or without using update strategy?
How to do unit testing in informatica?
What is domain and gateway node?
How do you handle two sessions in Informatica
How can we use mapping variables in informatica? Where do we use them?