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?

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

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,


How can we do null handling in sequential files?

3 Answers   Reliance,


Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,


How can we run same job in 1 day 2 times

4 Answers   IBM,


Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  






What is the roundrobin collector?

0 Answers  


How do u set a default value to a column if the column value is NULL?

7 Answers   HP,


I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,


what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,


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

0 Answers   HCL,


how to load meta data

2 Answers   IBM,


What are the functionalities of link partitioner and link collector?

0 Answers  


Categories