How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 7910 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
Write the unconnected lookup syntax and how to return more than one column.
Differentiate between sessions and batches?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is the size of your data warehousing?
What is a difference between complete, stop and abort?
Clarify the aggregator change?
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 is dimensional table?
How to call shell scripts from informatica?
What is resilience time?
How do you set a varible in incremental aggregation
What are the different versions of informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the etl program with few examples.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
