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
- 10953 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
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Triggers,VIEW,Procedures
How many types of views are there in a datastage director?
Describe routines in datastage? Enlist various types of routines.
what is 'reconsideration error' and how can i respond to this error and how to debug this
Highlight the main features of datastage?
How to clean the datastage repository?
What are the difference types of stages?
How a source file is populated?
what is the use of skid in reporting?
Differentiate between data file and descriptor file?
whom do you report?
in oracle target stage when we use load option and when we use upsert option?
How do you import and export the datastage jobs?
