Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sehaj
Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
What is meant by incremental aggregation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the different lookup cache(s)?
Describe data concatenation?
What is standalone command task?
What is exclusive and normal mode for repository services?
Partition, what happens if the specified key range is shorter and longer
explain about unit testing? in real time?
can u give example for factless fact table
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
what is unit testing?tell me proceedure
What are the new features of Power Center 5.0?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is an Integration service in Informatica?
