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 :):)

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

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.

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

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

Answer / lokendra

wt ever above saying is correct.

Answer / srinu

I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans

I am not confident check itonce let me know,,

Thanks
Srinu

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

Explain the difference between a data warehouse and a data mart?

0 Answers  

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

What is confirmed dimension with scenario

1 Answers   HCL,

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

What are the differences between oltp and olap?

0 Answers  

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,