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
- 12352 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / cgi
Take sequential file and use sort stage and set keychange
column=true,put filter to output the data to two links, one
is kechange is 0 and other is for 1. first link is directly
goes to join stage and other stage should go to copy
stage.In the copy stage change the company column name to
company2 and populate to join. in the join stage provide
the key column to 'name' and do inner join. u will get
output as required.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the difference types of stages?
What are the different common services in datastage?
How many Key we can define in remove duplicate stage?
What is the roundrobin collector?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are orabulk and bcp stages?
How to perform incremental load in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you register plug-ins?
Differentiate between validated and Compiled in the Datastage?
What is ds designer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
in oracle target stage when we use load option and when we use upsert option?
CHANGE CAPTURE
Nls stands for what in datastage?
