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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names ..

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

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names ..

Answer / ashutosh g

use rowsplitter stage

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is meta stage?

0 Answers  

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

How do you design PX Routines ?

1 Answers  

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

How we can covert server job to a parallel job?

0 Answers  

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

0 Answers  

what is the diff between sequential file and fileset stages?

3 Answers  

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

What are transforms and what is the differenece between routines and transforms?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories