Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How you can fix the truncated data error in datastage?

1749


What is data partitioning?

1179


How do you reject records in a transformer?

1107


What are constraints and derivations?

1151


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3453


In Datastage, how you can fix the truncated data error?

1146


What are the stages in datastage?

1075


What are the functionalities of link partitioner?

1004


how do u catch bad rows from OCI stage? And what CLI stands for?

2787


Can you define merge?

1101


What is the difference between hashfile and sequential file?

1242


Differentiate between operational datastage (ods) and data warehouse?

1154


What is quality stage?

975


Difference between sequential file and data set?

1186


Terminate Activity

1260