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
- 11242 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / venkata ramana
Input Seq File:-
NAME,LOC
Ram,hyd
Ram,ban
Raj,chn
Raj,Pun
Sam,del
seq---Trans---Rem Dups----> Dataset
TRANSFORMER:
------------
STEP1:
Create 3 stage variables like s1,s2,s3
DSLink3.NAME --->s1
If s1<>s3 then DSLink3.LOC else s2:DSLink3.LOC --->s2
s1--->s3
STEP2:
Derivations Column bane
s2------------> LOC
Remove duplicate stage:
-----------------------
Key == NAME
Duplicate To Retain = Last
Output Dataset result:-
NAME LOC
Ram Hyd ban
Raj chn pun
sam del
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the environmental settings for data stage,while working on parellel jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you explain link buffering?
Can we use Round Robin for aggregator?is there any benefit underlying?
What is the version control how can i apply this in DataStage can any one tell me the anser
What is the difference between an operational datastage and a data warehouse?
How a routine is called in datastage job?
How to remove blank spaces from data?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
what are the devoleper roles in real time? plz tell i am new to datastage....
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
in aggregator , how can i get the sum in readable format
Teradata 
