Answer Posted / prathibha

Hi,

Source->SQ->Sorter->Expression->FilterTarget.
Lets take a small example for this scenario.
Use a sorter to sort the input data.
ID Name
1 A
1 A
2 B
3 C
3 C

In Expression Transformation declare the following ports:

ID
Name
O_Count= iiF(V_port=ID,O_Count=O_count+1,O_Count=0)
V_port(Variable Port) = ID;

In filter transformation give the condition O_Count =0;
Let me know if there are any suggestions.

Explain Dataware house architecture .how data flow from intial to end?

2584

---

Explain the tuning lookup transformation - informatica

996

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

---

where to store informatica rejected data? How to extract the informatica rejected data?

1007

---

What is joiner change?

1148

---

How to join three sources using joiner?

1115

---

What is parallel processing in informatica?

1714

---

Is stop and abort are same in informatica?

1002

---

How can informatica be used for an organization?

1220

---

How to create Target definition for flat files?

1227

---

Enlist some properties of sessions.

1075

---

Differences between version 7.x and 8.x.

1895

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

What are the transformations that are not supported in mapplet?

1032

---

How to call shell scripts from informatica?

999

---