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
- 11266 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 do you see different stages in the designer?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the difference between datastage and informatica?
what is 'reconsideration error' and how can i respond to this error and how to debug this
options available in sequence job to run,validate?
What is the difference between the local container and shared container?
How to reverse the string using unix?
What is the project in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
whom do you report?
What is the command line function to import and export the ds jobs?
Define oconv () and iconv () functions in datastage?
Define data aggregation?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
