Interested to Buy Any Domain ? << Click Here >> for more details...
How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 8349 Views
- I also Faced
- E-Mail Answers
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 is the difference between informatica6.1 and infomatica7.1
What is pmcmd command?
How can we use batches?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
difference between repository database and repository service?
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between Load Manager and DTM?
How to extract the informatica rejected data?
How will the document be delivered to me?
What are the different clients of powercenter?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Where do we use mapping variables in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
What is main use of mapplet?
What is the surrogate key?
