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
- 13866 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 expression transformation?
What are the types of presistent cache in look up tr.
What is the surrogate key?
What are the main issues while working with flat files as source and as targets ?
What are the components of workflow manager?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to Create a folder using pmrep command?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the format of informatica objects in a repository?
Describe expression transformation?
How many transformations can be used in mapplets.
wat are deployement groups in informatica, how it will be used for developers
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the use of target designer?
