Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x
- 7 Answers
- 11234 Views
- I also Faced
- E-Mail Answers
Answer Posted / sree
using expersion
u can create o/p in that write
replacestr(1,columnname,'&','and')
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How do you schedule or monitoring the job?
what is the use of materialized view?
How to clean the datastage repository?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the primary usages of datastage tool?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the repository tables in datastage?
Difference between server jobs & parallel jobs?
Can you explain kafka connector?
What are stage variables and constants?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the importance of the exception activity in datastage?
