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
- 8226 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
without table how to come first record only in oracle?
Where can we find the throughput option in informatica?
How to generate sequence numbers?
where to store informatica rejected data?
Explain scd type 3 through mapping.
what is size of u r database?
whats the logic to load the lower level of granularity of data to fact table.
How do you load only null records into target? Explain through mapping flow.
How we can create indexes after completing the load process?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we update a record in the target table without using update strategy?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to extract sap data using informatica? What is abap? What are idocs?
What is transformation?
Explain sessions and how many types of sessions are there?
