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.

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4771

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

596

---

What do you mean by filter transformation?

548

---

Is there any target staging area in informatica not staging area

2120

---

---

During the running session, output files are created by informatica server. Enlist few of them.

537

---

generate date / time dimension in informatica

715

---

Define pmcmd command?

617

---

How do you load only null records into target? Explain through mapping flow.

1492

---

Under what condition selecting sorted input in aggregator may fail the session?

655

---

What are session parameters ? How do you set them?

1371

---

server hot-ws270 is connect to Repository B. What does it mean?

1848

---

What is a filter transformation and why it is an active one?

558

---

EXL informatica Questions

929

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493

---