Interested to Buy Any Domain ? << Click Here >> for more details...
I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 13916 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / venkatesh
The flow will be like this
src----->sorter---->transformer----->remove duplicates---->trg
SORTER
in sorter sort by the key=empname and create keychange column
TRANSFORMER
create two stage variables stg1 and stg2
if key change=1 then company else stg2 :',': company |stg1
_____________________________________________________|_____
|
stg1 |stg2
connect the stg1 as out put column and empname as output
from transformer connect to the remove duplicates
REMOVE DUPLICATES
key=empname
duplicates to retain=last
connect to the trg
u will get the output
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Define repository tables in datastage?
what is flow of project?
What is quality stage?
Can you define merge?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are stage variables?
What are the types of views in datastage director?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is difference between server jobs & parallel jobs?
What is datastage engine?
Can you filter data in hashed file?
what is ds administrator used for?
What are the types of jobs we have in datastage?
