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
- 8312 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krithi
When you use 'Select Distinct' option , the Sorter
Transformation discards the duplicate records.
If you want to trace out the duplicate records, then send
the sorted data into Expression Transformation. Add a new
variable and compare the variable with the input data. If
the data matches then flag the record or else pass the
default row.And load all the flagged records into a
seperate table.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
What are the basic needs to join two sources in a source qualifier?
A session S_MAP1 is in Repository A. While running the session error message has displayed
what is work of PUSH DOWN option
What does command task mean?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is souce qualifier transformation it is active or passive
what is target update override and when we use it?
what is song in infrmatica...?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how to run 2 workflows sequentially. plz respond what is the process?
Can we have a Mapping without a Source Qualifier?
Teradata 
