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

What are the different types of lookups in datastage?

1059


Why fact table is in normal form?

1261


How do you generate sequence number in datastage?

1101


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3350


On which Dimension Table you implemented SCD Type in your Project

2054


Could anyone give brief explanation bout datastage admin

2356


Can you filter data in hashed file?

3780


What is the roundrobin collector?

1100


What is the sortmerge collector?

1133


What are the different layers in the information server architecture?

1129


What are data elements?

1181


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2731


What are the different kinds of views available in a datastage director?

1033


What are the main differences you have observed between 7.x and 8.x version of datastage?

1089