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.

I have a flat file, want to reverse the contents of the flat file

1169

---

What is Index Caches size?

1161

---

On which transformations you created partitions in your project?

1429

---

What is domain and gateway node?

1204

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2309

---

What are session parameters ? How do you set them?

1899

---

Please let me know how to make Data masking in informatica..

1770

---

Different qualification between a related rotate toward the sky and isolates look upward?

1035

---

Explain the etl program with few examples.

1113

---

What is the fact table?

1132

---

explain one complex mapping with logic? sales project?

6729

---

Differentiate between reusable transformation and mapplet.

1141

---

What is a repository? And how to add it in an informatica client?

1192

---

How many ways are there to do 'remove duplicate records in informatica'?

1062

---

difference between informatica 8.1.1 and 8.6

3729

---