How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
Answer Posted / sudhar
You can use distinct to eliminate the duplicate records.
Otherwise if you wanted to send the duplicate records to
another table then sort the data, then using the expression
you can find the duplicate value, assign different constant
values for the duplicate and the normal one. Use the router
to send duplicate and orginal records to the different
target tables.
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
How to open an older version of an object in the workspace?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the need of an ETL tool?
Performance tuning( what you did in performance tuning)
Reusable transformation and shortcut differences
What are the main features of Oracle 8i with context to datawarehouse?
EXL informatica Questions
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Where is metadata stored?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is different between the data warehouse and data mart?
What is the Rank index port in Rank transformation?
Explain joiner transformation in informatica