Answer Posted / aswin
use aggregator and do not apply any aggregation function, it will return only last row in the group..if you dont provide any groupby and aggregate value it will return only last row..so you can aviod dups
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define filter transformation?
How to do unit testing in informatica? How to load data in informatica ?
I have a flat file, want to reverse the contents of the flat file
What is the difference between a connected look up and unconnected lookup?
How are indexes created after completing the load process?
Could you explain what is enterprise data warehouse?
Sequence generator, when you move from develoment to production how will you reset
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain the pipeline partition with real time example?
what is the complex transformation you used in informatica
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by target load plan?
What is confirmed fact in dataware housing?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many numbers of sessions can one group in batches?