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
- 8282 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 size of your data warehousing?
What do you mean by blocking transformation?
What are the differences between a connected lookup and unconnected lookup?
What are the advantages of informatica?
Differentiate between sessions and batches?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is workflow monitor?
What are the different clients of powercenter?
How do you load first and last records into target table?
How can we use mapping variables in informatica?
How many ways are there to create ports?
Write the unconnected lookup syntax?
Differentiate between a database and data warehouse?
Explain the informatica workflow?
What is native users?
