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

Can we create two repositories on same database instance in oracle?

600

---

Mention some types of transformation?

597

---

what is informatica metadata?

587

---

What is a dimensional model?

571

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

696

---

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1739

---

What do you understand by a term domain?

657

---

what are the Methods For Creating Reusable Transformations?

638

---

How to use pmcmd utility command?

569

---

Suppose we do not group by on any ports of the aggregator what will be the output?

561

---

How to extract the informatica rejected data?

739

---

How do you promote a non-reusable transformation to reusable transformation?

651

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1616

---

What is meant by active and passive transformation?

574

---

what is degenerated dimension?

3138

---