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
- 7930 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 |
If the job aborted in a sequencer, how can we start that from the previews successful job.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
How do you reject records in a transformer?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
difference between server shared container and parallel shared container
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to cleansing data
How do u convert the columns to rows in datastage?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
Teradata 
