I have a scenario where i will be getting a source which is a result of appending of 2 files. Now when i read the file in datastage i have to split the file into 2 different files.
The file has 2 headers and the data from the first header to the starting of second header should go to one file and the data from second header should go to second file
Ex;
Code: Select all
Header1 12287898980
A ,1, 2 , 1qwewew
....
.....
Header2 1238909877
b,e,t,234445,
...
I am using Datastage 7.5 EE and also the no of records keep on varying.