Then We have to concatenate by using concatenation operation with comma(,)

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?

Question Posted / santhu

5 Answers
10863 Views
I also Faced
E-Mail Answers

Answer Posted / santhu

Then We have to concatenate by using concatenation operation with comma(,)in transformer

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Enlist various types of routines in datastage.

1328

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3810

What is the difference between datastage and informatica?

1181

What is the difference between operational data stage (ods) and data warehouse?

1292

What is a merge?

1238

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2662

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

What is quality stage?

1043

What all the types of jobs you developed?

1246

What is a datastage job?

1054

What are the various kinds of containers available in datastage?

1100

What is a ds designer?

1112

How to convert RGB Value to Hexadecimal values in datastage?

4053

What is the differentiate between data file and descriptor file?

1411

Which warehouse using in your datawarehouse

2233