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
- 8434 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 |
How can i send first half of the records to one target and Remaining to other target?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Where should yoU place the flat file to import the flat file defintion to the designer?
How to prepared lld.can any one tell me detailed explanetion.
Explain transaction control transformation in informatica
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
what is the size of u r project? and what is the size of source file?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
WHat all joins are there in Source Qualifier?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
Teradata 
