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
- 14377 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Venkatesh is Absolutely right but unfinished. After remove
duplicate stage we have to use either column import stage or
transformer stage.
SEQ>>>TRANS>>>REMOVEDUPLICATE>>>COLUMNIMPORT/TRANSFORMER>>>TARGET
if Transformer: use field function in derivation
for company1: field(company,',',1)
company2: filed(company,',',2)
for column import stage: specify the key column: company
default delimeter: ','
columns: company1 and company2
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the stages in datastage?
What are the different types of lookups in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the process of killing a job in datastage?
what is ds administrator used for?
What is the roundrobin collector?
What are the components of datastage?
how to add a new records into source?
How we can covert server job to a parallel job?
What are stage variables?
Can you explain engine tier in information server?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are system variables and sequencers in datastage
Where do the datastage jobs get stored?
How do you generate sequence number in datastage?
