Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 11071 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vivekk
Src-->SQ-->AGG-->RTR--->TG1 & TG2
In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the types of transformations?
What is the sql query overwrite in source qualifier in informatica
What are the prerequisite tasks to achieve the session partition?
What are the components of the workflow manager?
explain about unit testing? in real time?
What is meant by active and passive transformation?
Why sorter is an active transformation?
what is size of u r database?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you update the records with or without using update strategy?
How to create Target definition for flat files?
What are the main features of Oracle 8i with context to datawarehouse?
