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.

what is INFORMATICA TESTING process

2226

---

Explain scd type 3 through mapping.

917

---

What are the static cache and dynamic cache in informatica?

1139

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10630

---

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

1013

---

Explain lookup transformation is active in informatica

1034

---

wf dont have integration severances how you can run?

1883

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047

---

How to join three sources using joiner? Explain though mapping flow.

1090

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2119

---

Which transformation is needed while using the Cobol sources as source definitions?

1124

---

Could you explain what is enterprise data warehouse?

1047

---

How to update source definition?

1030

---

What is the advantage of informatica?

1013

---

Have you worked with/created Parameter file

1611

---