Answer Posted / shridhar kasat

For Unique and Duplicate , we can go for same flow :

Source-->SrcQualifier-->Aggregator(group
by this column and find count also)--> then use joiner (use
the column from Source qualifier and join the data from
Aggregator as source qualifier.col=aggregator.col) -->
Router (insert into t1 for count>1 and for count=1 insert
into t2). t1 is for duplicate records and it will cintain
1,1,3,3 and t2 will have 2,4.

Records in Source Q :
col
1,1,2,3,3,4

The records after agregator will look like this :
col count
1 2
2 1
3 2
4 1

Records after Joiner : source q.col=aggregator.col
col count
1 2
1 2
2 1
3 2
3 2
4 1

These records will flow in router and we define two groups;
one for count>1 (for duplicates record) and second for
count=1 ( for unique record)

Hope this answer suffice your requirements.

Regards
Shri

Why filter transformation is an active one?

1033

---

Define the various join types of joiner transformation?

1042

---

What is data transformation manager process?

1222

---

What are active and passive transformations?

1134

---

What are the new features of informatica 9.x at the developer level?

1106

---

What is a repository manager?

1148

---

How to elaborate powercenter integration service?

1175

---

What is the need of an ETL tool?

1160

---

How do you handle two sessions in Informatica

1220

---

Can we override a native sql query within informatica?

1092

---

Quickly characterize reusable change?

1184

---

What are the types of schemas we have in data warehouse and what are the difference between them?

989

---

How to delete duplicate row using informatica?

1090

---

Slowly changing dimensions, types and where will you use them

1773

---

what is the complex transformation you used in informatica

2624

---