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
Answer Posted / ashok
TRANSFORMER:
------------
STEP1:
Take 3 stage variables
NAME--->s1
if s1<>s3 then LOC else s2:LOC --->s2
s1--->s3
STEP2:
In derivations s2--->LOC Field
Remove duplicate stage:
-----------------------
Retaining last
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a merge?
Lookup constraints
How a routine is called in datastage job?
What is the difference between validated and compiled in the datastage?
How many Key we can define in remove duplicate stage?
What is the difference between operational data stage (ods) and data warehouse?
Define Routines and their types?
Define repository tables in datastage?
Explain the situation where you have applied SCD in your project?
Can you define merge?
What is job control?
What is datastage engine?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Is it possible to query a hash file?