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
- 11089 Views
- HCL, I also Faced
- E-Mail Answers
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
How rejected rows are managed in datastage?
How do you register plug-ins?
What is the difference between orabulk and bcp stages?
What are routines in datastage? Enlist various types of routines.
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
Highlight the main features of datastage?
How do you run datastage job from the command line?
How many Key we can define in remove duplicate stage?
Can you explain link buffering?
Distinguish between informatica & datastage. Which one would you choose and why?
Give an idea of system variables.
How to reverse the string using unix?
What steps should be taken to improve Datastage jobs?
What is the difference between odbc and drs stage?
what is flow of project?
