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
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How might one distinguish in the case of mapping is right or not without associating session?
What the difference is between a database, a data warehouse and a data mart?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
permutations of mapplet
What is olap (on-line analytical processing?
What is lookup transformation?
Under what condition selecting sorted input in aggregator may fail the session?
update strategy transformation in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is event and what are the tasks related to it?
What is rank transformation in informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the need for an etl tool?