How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
Answer Posted / 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 |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the informatica performance improvement tips
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the size of u r source(like file or table)?
Why update strategy and union transformations are active?
What do you understand by a term domain?
What are the restrictions of union transformation?
How can informatica be used for an organization?
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?
Differences between version 7.x and 8.x.
How to load the data from a flat file into the target where the source flat file name changes daily?
What is blocking transformation?
What are the different options available for update strategy?
What are the different components of powercenter?
Define mapping and session?