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
- 11363 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 is difference between server jobs & parallel jobs?
What are transforms and what is the differenece between routines and transforms?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
where we use column generator stage in real time scenario?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Can you explain players in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is ibm datastage?
How many number of reject links merge stage can have?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
How do you run datastage job from the command line?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Teradata 
