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
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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How many Key we can define in remove duplicate stage?
What steps should be taken to improve Datastage jobs?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Is possible to create skid in dim,fact tables?
Define Routines and their types?
what is the use of surogate key in datastage
EXPLAIN SCD
Differentiate between odbc and drs stage?
Differentiate between data file and descriptor file?
Which warehouse using in your datawarehouse
Can you explain link buffering?
What is the difference between validated and compiled in the datastage?
What is a ds designer?
How one source columns or rows to be loaded in to two different tables?