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

Enlist the advantages of informatica.

1002

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2051

---

What is informatica?

1075

---

What is the need for an etl tool?

1009

---

How to generate sequence numbers without using the sequence generator transformation?

1112

---

Explain direct and indirect flat file loading (source file type) - informatica

1261

---

Clarify the aggregator change?

968

---

can anyone suggest best free Talend data integration training online

1622

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2039

---

Briefly explain the aggregator transformation?

941

---

Define enterprise data warehousing?

1128

---

Under which circumstances, informatica server creates reject files?

1025

---

Which development components of informatica have the highest usage?

983

---

which one is better performance wise joiner or look up

1025

---

Is there any target staging area in informatica not staging area

2505

---