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

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

What is meant by target load plan?

0 Answers  

---

how to obtain performance data for individual transformations.

2 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

explain about unit testing? in real time?

0 Answers   L&T,

---