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
- 8189 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 a pre-defined event and user-defined event?
What is the difference between a repository server and a powerhouse?
what is the hint? how to use it to reduce the query processing in program?
How to improve the performance of a session using sorter transformation?
Scheduling properties,whats the default (sequential)
What is decode in informatica?
Which is the t/r that builts only single cache memory?
Please let me know how to make Data masking in informatica..
without table how to come first record only in oracle?
I have a flat file, want to reverse the contents of the flat file
COM components can be used in Informatica
Design a mapping to load a target table with the following values from the above source?
what is $$$$?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
how we can load rejected record's at run time?(not through bad files)
