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
- 11604 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shalu
giving one example, lets say my table temp is having
following -
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
In the SQL Qualifier, override the query as
select col1,col2,count(1) total from temp group by col1,col2
which shows the output as
col1 col2 total
1 2 3
3 4 2
5 6 1
Now, use one router transformation where one condition is
where total >=1
and second condition where total>1
So first condition will return you all the unique records
1 2
3 4
5 6
and second condition will return you duplicate records
1 2
3 4
| Is This Answer Correct ? | 19 Yes | 5 No |
Answer / sankar
AS PER Reddevilzzzz ANS ALMOST OK
BUT NO NEED TO SELECT GROUP BY IN AGGREGATOR T/R BCOZ IF U
SELECT GROUP BY THERE IS NO DUPLICATE SO WITH OUT
DUPLICATES HOW WE PASS THE DUPLICATES IN T2.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / hitesh
but in this we ll get distinct values in duplicate table.
how can i get all values in duplicate table like:
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
and i want
unique table:
5 6
and
duplicate table :
1 2
1 2
1 2
3 4
3 4
i know this is of no use, but can we do this??
pls rply
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nikita jain
for this query we can use aggregator row wise calculation and handle then via router
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
O/P
Table with unique records:
1 2
3 4
5 6
Table with rest of the records
1 2
1 2
3 4
After SQ take a sorter transformation sort on col1 asc then an expression transformation
col1
col2
v_count iif(col1=prev_col1 and col2=prev_col2, vcount+1,1)
o_count v_count
prev_col1 col1
prev_col2 col2
Take a Router transformation , make 2 groups
Group1 : 0_count=1
Group2 : Default (it will come automatically)
Connect first group with unique target table
and second with other table
| Is This Answer Correct ? | 0 Yes | 0 No |
Performance tuning in UNIX for informatica mappings?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the out put files that the informatica server creates during the session running?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can a joiner be used in a mapplet.
what is confirmed dimension?
Explain direct and indirect flat file loading (source file type) - informatica
What is a command that used to run a batch?
What are the differences between oltp and olap?
What is update strategy transform?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
Teradata 
