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
- 8333 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the components of workflow manager?
What is informatica metadata and where is it stored?
what is index?how it can work in informatica
I have a flat file, want to reverse the contents of the flat file
Is it possible to use a client with different version than that of its Informatica server?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How can you validate all mappings in the repository simultaneously?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the types of caches in lookup?
What is rank transform?
Enlist the advantages of informatica.
What are the uses of etl tools?
How to load the data from a flat file into the target where the source flat file name changes daily?
What do mean by local and global repository?
How many types of sessions are there in informatica.please explain them?
