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
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 |
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
How can we do null handling in sequential files?
Difference between JOIN,LOOKUP,MERGE?
How can we run same job in 1 day 2 times
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What is the roundrobin collector?
How do u set a default value to a column if the column value is NULL?
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?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how to load meta data
What are the functionalities of link partitioner and link collector?