Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 11097 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
Where the datastage stored his repository?
What steps should be taken to improve Datastage jobs?
Can you define merge?
How do u convert the columns to rows in datastage?
What is the difference between in process and inter process?
What a datastage macro?
What are constraints and derivations?
What is the difference between datastage and datastage tx?
What is difference between join, merge and lookup stage?
How to RD using transformer?
What are the functionalities of link collector?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Why fact table is in normal form?
What is a merge?
What are data elements?
