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
- 13597 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
What is an Integration service in Informatica?
What is lookup transformation?
What is workflow? What are the components of workflow manager?
How can we create index after completion of load process?
Why update strategy and union transformations are active? Explain with examples.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a snowflake schema?
What are the components of workflow manager?
Can u generate reports in Informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the guidelines to be followed while using union transformation?
What is confirmed fact in dataware housing?
Explain load alternative records / rows into multiple targets - informatica
r u done any partitions in ur project?
difference between informatica 8.1.1 and 8.6
