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
How you can fix the truncated data error in datastage?
What is data partitioning?
How do you reject records in a transformer?
What are constraints and derivations?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
In Datastage, how you can fix the truncated data error?
What are the stages in datastage?
What are the functionalities of link partitioner?
how do u catch bad rows from OCI stage? And what CLI stands for?
Can you define merge?
What is the difference between hashfile and sequential file?
Differentiate between operational datastage (ods) and data warehouse?
What is quality stage?
Difference between sequential file and data set?
Terminate Activity