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
- 9694 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi srinivas
By using convert function in transformer,we can implement
that....
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define ds designer?
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)
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How to find value from a column in a dataset?
How many types of stage?
How a source file is populated?
Can you explain how could anyone drop the index before loading the data in target in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are constraints and derivations?
Why do you need stage variables?
Describe the main features of datastage?
How complex jobs are implemented in datstage to improve performance?
