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
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What a datastage macro?
What is aggtorec restructure operator?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Differentiate between datastage and datastage tx?
what is the use of materialized view?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Terminate Activity
What is size of a transaction and an array means in a datastage?
How to RD using transformer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the different kinds of views available in a datastage director?
What are data elements?
Explain the importance of surrogate key in data warehousing?
What is the flow of loading data into fact & dimensional tables?