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
- 7871 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 |
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
how to handle null values using transformer stage?
What are stage variables and constants?
where we use column generator stage in real time scenario?
What is the function in Transformer stage can act as Rank Function in oracle
in oracle target stage when we use load option and when we use upsert option?
Is the value of staging variable stored temporarily or permanently?
Why fact table is in normal form?
how to get the unique records on multiple columns by using sequential file stage only
What is the purpose of interprocessor stage in server jobs?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
Teradata 
