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


Please Help Members By Posting Answers For Below Questions

Differentiate between operational datastage (ods) and data warehouse?

668


Difference between data warehousing and olap?

645


How a source file is populated?

606


Is it possible to query a hash file?

1554


Define data aggregation?

660






How do you schedule or monitoring the job?

657


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2004


What are the types of containers?

675


What are the different type of jobs in datastage?

602


What is the command line function to import and export the ds jobs?

675


How to reverse the string using unix?

2793


What is a ds designer?

636


options available in sequence job to run,validate?

825


how to write server Routine coding?

1657


How many types of stage?

667