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
- 10661 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
Explain ibm infosphere information server and highlight its main features?
What are the functionalities of link collector?
what is flow of project?
How one source columns or rows to be loaded in to two different tables?
What are stage variables and constants?
What is aggtorec restructure operator?
Enlist various types of routines in datastage.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Explain usage analysis in datastage?
how to add a new records into source?
Can you explain repository tables in datastage?
table actions available in oracle connector?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the roundrobin collector?
What is a datastage job?
