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?
- 2 Answers
- 7769 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is the purpose of pivot stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to implement complex jobs in data stage?
Is possible to create skid in dim,fact tables?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What all are the different way to run a job?
what is the difference between == and eq in UNIX shell scripting?
how to abort the job its matain duplicates?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Teradata 
