i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4

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

3 Answers
5914 Views
I also Faced
E-Mail Answers

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