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 can you define user defied event?

1022

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1693

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7212

---

If informatica has its scheduler why using third party scheduler?

1255

---

What is informatica etl tool?

996

---

What are the various types of transformation?

1171

---

What are the guidelines to be followed while using union transformation?

1132

---

Separate from an archive server and a powerhouse?

953

---

What does reusable transformation mean?

1130

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2127

---

What is rank transform?

989

---

what is the size of your data warehousing?

2091

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1946

---

what is the size of u r source(like file or table)?

2265

---

What is meant by lookup transformation? Explain the types of lookup transformation?

943

---