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?
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 is the use of datastage designer?
What is the difference between odbc and drs stage?
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
What is the flow of loading data into fact & dimensional tables?
What is the command line function to import and export the ds jobs?
What are data elements?
Can you highlight the main features of ibm infosphere information server?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the purpose of pivot stage?
Describe link sort?
What is the difference between the local container and shared container?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the important features of datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Nls stands for what in datastage?