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
- 13926 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / murali
Take the seq file stage and transformer and data set. in
transformer stage take two stage variables st1,st2 set the
intial value as '0' and data type is 'varchar' for st1
in st2 by using concatenate st1:',':st2
| Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Can we use target hash file as a lookup ?
what are the devoleper roles in real time? plz tell i am new to datastage....
in oracle target stage when we use load option and when we use upsert option?
What is the purpose of interprocessor stage in server jobs?
What are the types of hashed files in data stage
How do you reject records in a transformer?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What can we do with datastage director?
What is active and passive stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
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
Lookup constraints
Differentiate between Join, Merge and Lookup stage?
