1)Sort the input (name as key),keychange colum =true we will get name loc

Hi
Can any one help regarding below

INPUT

NAME LOC
Ram hyd
Ram ban
Raj chn
Raj Pun
Sam del

OUPUT

NAME LOC
Ram Hyd ban
Raj chn pun
sam del

Question Posted / vikram

3 Answers
11364 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / vikram

1)Sort the input (name as key),keychange colum =true
we will get
name loc key..
ram hyd 0
ram ban 1
raj chn 0
raj pun 1
sam del 0

2)transformer
stage variable
svVar=if key..=0 then loc else svVar:loc
3) remove duplicate stage
retain duplicate last

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is orabulk stage?

1105

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2416

What are the features of datastage flow designer?

1099

What all are the different way to run a job?

1139

What all the types of jobs you developed?

1248

What are the enhancements made in datastage 7.5 compare with 7.0?

1210

Is it possible to query a hash file?

2062

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2932

What is datastage?

1133

What is the difference between account and directory options ?

1234

what is the difference between == and eq in UNIX shell scripting?

1558

Can you explain tagbatch restructure operator?

1219

How many Key we can define in remove duplicate stage?

1444

Notification Activity

1460

options available in sequence job to run,validate?

1364