Answer Posted / suman chattopadhyay

Shirish,

Part 1 of your answer is not correct. If you use distinct
option in sorter you will get all the distinct values even
for the duplicate. i.e if the values are 1,1,2,3,3,4, you
will get 1,2,3,4 in target.

Part 2 of your answer will do all the trick for duplicate
and unique ones. If you use group by and count the number
of occurences you will get 1 as the count for unique values
and more than one as count for duplicate values. Pass those
records with count 1 to 1 target and the other to the 2nd
target.

Hope this helps.

Suman

What are the issues you have faced in your project? How did you overcome those issues?

2412

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1111

---

How do you load unique records into one target table and duplicate records into a different target table?

1314

---

What is InformaticaPowerCenter?

1177

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1210

---

What are the tuning techniques you applied during your last project

2073

---

How does a sorter cache works?

1109

---

generate date / time dimension in informatica

1160

---

Can u generate reports in Informatica?

1143

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577

---

What are the different types of repositories created using informatica?

1168

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339

---

What are the types of lookup transformation?

1117

---

scenario where i can use only concurrent execution of workflow.

3257

---

What is an aggregator transformation?

1143

---