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
- 10861 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
Describe the main features of datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are stage variables, derivations and constants?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Describe stream connector?
client know skid info?
How do you start developing a datastage project?
which r the connectors used in san?
What all are the different way to run a job?
Explain Quality stage?
What is the process of killing a job in datastage?
What is the differentiate between data file and descriptor file?
How a routine is called in datastage job?
How to manage date conversion in Datastage?
What are the primary usages of datastage tool?
