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 functionalities of link partitioner?
What are some prerequisites for datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Have you used Unstructured data?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define APT_CONFIG in Datastage?
What is apt_config in datastage?
Where do you see different stages in the designer?
what is the use of skid in reporting?
Define oconv () and iconv () functions in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you explain kafka connector?
Difference between in process and inter process?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?