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
- 9695 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
how to sort two columns in single job in datastage.
What are some prerequisites for datastage?
What is the difference between orabulk and bcp stages?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the steps needed to create a simple basic datastage job?
What are the types of hashed files in data stage
What is orabulk stage?
What are the different options associated with dsjob command?
Define Merge?
What are system variables and sequencers in datastage
whom do you report?
What is the difference between Datastage 7.5 and 7.0?
How many types of views are there in a datastage director?
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.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
