1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have two coloumn
emp_no sal
1 3000
2 3000
3 3000
4 4000
5 5000
6 2700
7 4500
i just need output by removing duplicate.my answer should be
emp_no sal
1 3000
2 4000
3 5000
and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

Question Posted / engr_umair85

Answers were Sorted based on User's Feedback



i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

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

Is This Answer Correct ?    3 Yes 0 No

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

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

Is This Answer Correct ?    1 Yes 1 No

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

Answer / nsatyabrat7

Use distinct in source qualifier and rest will be taken care

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,




Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

What does command task mean?

0 Answers  

What are mapplets?

0 Answers  

What is the difference between procedure and stored procedur?

2 Answers   IBM,

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

For more Informatica Interview Questions Click Here
Categories