Interested to Buy Any Domain ? << Click Here >> for more details...
if a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to
place names separated by commas in another columns how can
we do?
- 5 Answers
- 10708 Views
- I also Faced
- E-Mail Answers
Answer Posted / pranay
seq file ------> Transformer -------> target
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are iconv and oconv?
What can we do with datastage director?
How do you import and export data into datastage?
project Steps,hits, Project level HArd things,Solved methods?
Does datastage support slowly changing dimensions ?
How do you schedule or monitoring the job?
What are the different kinds of views available in a datastage director?
How to reverse the string using SQL?
What are the different plug-ins stages used in your projects?
Can you explain engine tier in information server?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
To see hidden files in LINIX?
What is the difference between server job and parallel jobs?
How can we improve performance of data stage jobs?
What is difference between symmetric multiprocessing and massive parallel processing?
