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
- 14363 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
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are data elements?
What is the difference between odbc and drs stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
which r the connectors used in san?
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?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between informatica and datastage?
Name the different types of Lookups in Datastage?
What are the different types of lookups in datastage?
What are orabulk and bcp stages?
What is the purpose of pivot stage and types of containers in datastage
What is a datastage job?
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...
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
