By using stage variable in transformer stg

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

2 Answers
7915 Views
IBM, I also Faced
E-Mail Answers

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

What a datastage macro?

1060

What are the components of ascential data stage?

1189

Define Merge?

1317

How many types of stage?

1179

What is the use of datastage designer?

1154

What can we do with datastage director?

1238

What are the types of containers and how to create them?

977

What is difference between symmetric multiprocessing and massive parallel processing?

1141

Which algorithm you used for your hashfile?

1182

How to reverse the string using unix?

3509

What is aggtorec restructure operator?

1452

how to export or import the jobs in .ISX file

1203

What is a merge in datastage?

1270

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

1550

Distinguish between informatica & datastage. Which one would you choose and why?

1010