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
- 9846 Views
- I also Faced
- E-Mail Answers
Answer Posted / manish
Using Convert function we can achieve this:
Convert('&',' and ',column string)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and informatica?
Define ds designer?
On which interface you will be working as a developer?
What is the sortmerge collector?
What is the difference between server job and parallel jobs?
Lookup constraints
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to convert RGB Value to Hexadecimal values in datastage?
What are the types of containers in datastage?
What is datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the steps needed to create a simple basic datastage job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you explain kafka connector?
What are the main features of datastage?
