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 using aggregator & router? how
- 7 Answers
- 13688 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / reddevilzzzz
@ Shalu
Your answer is almost correct. The question says, you have
to use Aggregator transformation.
Select all the rows from SQ.
Pass them to aggregator transformation. Group By on all
ports.
Create a Output port in Aggregator(lets call it TOTAL) and
give expression as COUNT(Col1).
Create a Router transformation, with 2 groups. In one group
(lets call it UNIQUE), put condition as TOTAL = 1.
In another group (lets call it DUPLICATES), put condition
as TOTAL>=2.
Pass the output from UNIQUE group to table where we want
unique rows.
Pass the output from DUPLICATE group to table where we want
duplicate rows.
P.S - tried and tested :):)
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
What is a standalone command task?
What is decode in informatica?
How many input parameters can exist in an unconnected lookup?
How we can use union transformation?
What is difference between a gateway node and worker node?
What are the restrictions of union transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Enlist the various types of transformations.
what is INFORMATICA TESTING process
Explain dynamic target flat file name generation in informatica
How union transformation is used?
Whats there in global repository
What are the informatica performance improvement tips
How can we use mapping variables in informatica? Where do we use them?
