Answer / rayudu

First in the pre_session command task remove the duplicates
using the following

cut -d "," -f2 filename|uniq

Now in the file you will have

3000
4000
5000
2700
4500

now after source qualifier keep a expression and generate
the sequence.

Hope it clarifies

Regards,
rayudu

Answer / jayachandra

One solution is use distinct key word on source qualfier as
suppose your table name is emp than on emp_sq
the query is

select emp_no,distinct sal from emp;

2nd sol is make an aggregator transformation here make a
coun()on sal port with group by then put filter
transformation with condition count(sal)=1

Answer / nsatyabrat7

Use distinct in source qualifier and rest will be taken care

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

How to extract sap data using informatica?

0 Answers  

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---