Answer / Ankita Tewari

To remove duplicates from a Flat File Source in Informatica, you can use the "Sort", "Filter", or "Aggregator" transformation. These transformations enable you to identify and eliminate duplicate records based on specific criteria.

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

On which transformations you created partitions in your project?

1 Answers   Cap Gemini,

---

What are the tuning techniques you applied during your last project

1 Answers  

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

what are the Methods For Creating Reusable Transformations?

1 Answers   Informatica,

---

can u any challenge your project?

1 Answers   HP,

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---