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
- 8202 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sudhar
You can use distinct to eliminate the duplicate records.
Otherwise if you wanted to send the duplicate records to
another table then sort the data, then using the expression
you can find the duplicate value, assign different constant
values for the duplicate and the normal one. Use the router
to send duplicate and orginal records to the different
target tables.
| Is This Answer Correct ? | 2 Yes | 4 No |
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is the cumulative sum and moving sum?
What is the difference between informatica 8.x and 9.x
As union transformation gives UNION ALL output, how you will get the UNION output?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
How the facts will be loaded? explain
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
what is the use of Data Mart?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
why we need informatica
What is the session task and command task?
Teradata 
