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
- 11255 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
Explain how a source file is populated?
How to find value from a column in a dataset?
Have you have ever worked in unix environment and why it is useful in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Triggers,VIEW,Procedures
How do you register plug-ins?
What are the steps needed to create a simple basic datastage job?
How a server job can be converted to a parallel job?
Explain the situation where you have applied SCD in your project?
What are the various kinds of the hash file?
What are stage variables and constants?
options available in sequence job to run,validate?
What are the various kinds of containers available in datastage?
Name the third party tools that can be used in datastage?
What are the features of datastage flow designer?
