How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 7407 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 |
What are the different types of repositories created using informatica?
What is informatica etl tool?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
When we are using Dynamic Cache,which options we will select in session level?
What is parameter file?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
What are the components of the workflow manager?
What is a parameter When and where do you them when does the value will be created
What is the surrogate key?
Why we require dwh in particular projects?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
how we can do session partition in informatica any one explain me clearly? thanks advance.
Teradata 
