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 / blueboys
Dear Srinu,
I am accepting your answer , but I need it by
using data stage functions
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are some different alternative commands associated with "dsjob"?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is size of a transaction and an array means in a datastage?
how to sort two columns in single job in datastage.
Distinguish between informatica & datastage. Which one would you choose and why?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Differentiate between data file and descriptor file?
Name the different sorting methods in datastage.
What are the different layers in the information server architecture?
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)
Notification Activity
What are the stages in datastage?
what is flow of project?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is difference between symmetric multiprocessing and massive parallel processing?