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
- 14193 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
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?
I have a few records just I want to store data in to targets cycling way how?
State the difference between an operational datastage and a data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is merge stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the flow of loading data into fact & dimensional tables?
On which interface you will be working as a developer?
Is the value of staging variable stored temporarily or permanently?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the components of datastage?
What are the different options associated with dsjob command?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the some differences between 7.x and 8.x version of datastage?
