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
- 12275 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
Triggers,VIEW,Procedures
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Difference between in process and inter process?
What is difference between join, merge and lookup stage?
What are the job parameters?
What is oci?
Notification Activity
Which warehouse using in your datawarehouse
what is the use of surogate key in datastage
Highlight the main features of datastage?
What is the difference between datastage and informatica?
Where do the datastage jobs get stored?
What are constraints and derivations?
What is use Array size in datastage
How to reverse the string using unix?
