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 / 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
Why fact table is in normal form?
What is a merge?
Whats difference betweeen operational data stage (ods) and data warehouse?
How one source columns or rows to be loaded in to two different tables?
Enlist various types of routines in datastage.
What are the types of views in datastage director?
What are the various kinds of containers available in datastage?
How the ipc stage work?
Where do you see different stages in the designer?
What is size of a transaction and an array means in a datastage?
options available in sequence job to run,validate?
What is the different type of jobs in datastage?
What is the difference between server job and parallel jobs?
Different ways a project can be moved to production ?...example ….export-import and Version control.
what is the difference between == and eq in UNIX shell scripting?