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
- 11366 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
Difference between server jobs & parallel jobs?
Explain connectivity between datastage with datasources?
What is the purpose of pivot stage and types of containers in datastage
What is the command line function to import and export the ds jobs?
Describe the main features of datastage?
Explain ibm infosphere information server and highlight its main features?
How many types of stage?
Why we use surrogate key?
How do u convert the columns to rows in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the primary usages of datastage tool?
How to Remove Duplicate using SQL?
What are the steps needed to create a simple basic datastage job?
What are the important features of datastage?
What are transforms and what is the differenece between routines and transforms?
