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?
Answer Posted / swapnil
By using stage variable in transformer
stg_name='' ( initialize)
stg_name=input.name : " , " : stg_name
_________
Transformer derivation
stg_name --> Target_name
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the various kinds of the hash file?
How do u convert the columns to rows in datastage?
What are the components of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How can one find bugs in job sequence?
How many types of views are there in a datastage director?
What is datastage?
What are constraints and derivations?
Difference between data warehousing and olap?
Can you explain players in datastage?
How to find value from a column in a dataset?
What are the different common services in datastage?
What are system variables and sequencers in datastage
What is the difference between datastage and datastage tx?
What is the difference between operational data stage (ods) and data warehouse?