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
- 8428 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
How can you increase the performance in joiner transformation?
What is fact table? Explain the different kinds of facts.
Why filter transformation is an active one?
What is persistent lookup cache?
What is the difference between informatics 7x and 8x and what is latest version?
EXL informatica Questions
What are the new features of informatica 9.x developer?
How to improve the performance of a session using sorter transformation?
What is a connected transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Differentiate between reusable transformation and mapplet.
What do you mean by filter transformation?
Explain direct and indirect flat file loading (source file type) - informatica
define galaxy repository in informatica
