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
- 13917 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tina
Use a lookup stage after the file. Do a self-lookup on this
file on empname. When the empname matches, take the empname
and company1 from stream link and company2 from reference
link and map to the target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is the different type of jobs in datastage?
What is a datastage job?
Explain Quality stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what are the errors,warnings in datastage
Have you have ever worked in unix environment and why it is useful in datastage?
Define project in datastage?
Define Routines and their types?
what is the use of surogate key in datastage
Define Merge?
Difference between server jobs & parallel jobs?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How to manage date conversion in Datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
State the difference between an operational datastage and a data warehouse?
