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 / abhishek

No Need of fileds and all extraact al the columns in
transfarmerstage create a new column in transe as exprestion
col1,col2,col3 and load it

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do u convert the columns to rows in datastage?

683


What is staging variable?

613


What is a folder? Difference types of stages?

615


Describe stream connector?

817


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2833






What is aggtorec restructure operator?

709


Differentiate between odbc and drs stage?

583


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2415


Notification Activity

888


what is the use of skid in reporting?

1945


What is datastage?

640


Explain entity, attribute and relationship in datastage?

623


What are the enhancements made in datastage 7.5 compare with 7.0?

702


Define Data Stage?

628


how to add a new records into source?

1514