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
- 8425 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 do mean by local and global repository?
What is a sorter transformation?
What are the new features of informatica 9.x in developer level?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the main issues while working with flat files as source and as targets ?
How big was your fact table
What are mapplets? How is it different from a Reusable Transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is meant by target load plan?
How can we use mapping variables in informatica?
Define filter transformation?
Explain the pipeline partition with real time example?
What is the procedure for creating independent data marts from informatica 7.1?
permutations of mapplet
can u give example for factless fact table
