How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 7868 Views
- I also Faced
- E-Mail Answers
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
What is decode in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the components of workflow manager?
Explian the Process of deployment groups in informatica
What are roles and groups and benefits of using them?
What are the features of complex mapping?
my source is junk data how will u remove that junk data by using unix please any one replay me
Quickly characterize reusable change?
How to call shell scripts from informatica?
What is update strategy transform?
How do you convert single row from source into three rows into target?
During the running session, output files are created by informatica server. Enlist few of them.
What is dimensional table?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can we delete duplicate rows from flat files?
