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

Have you worked with/created Parameter file

1667

---

Scheduling properties,whats the default (sequential)

1960

---

What is the difference between router and filter?

1274

---

Explain the etl program with few examples.

1054

---

what is the Default Source Option For Update Strategy Transformation?

1243

---

How to open an older version of an object in the workspace?

1208

---

what is the size of your data warehousing?

2096

---

What are the tuning techniques you applied during your last project

2027

---

State the limitations where we cannot use joiner in the mapping pipeline?

1068

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

---

What you know about transaction control transformation?

996

---

What are the components of Informatica? And what is the purpose of each?

1056

---

What is persistent lookup cache?

1035

---

What is status code in informatica?

1024

---

Briefly define a session task?

1138

---