we are facing issue when we used a sequential file stage in on of our jobs.
what we actually doing in the job is we fetch data from a oracle stage and use remove duplicates stage and then store the data in the sequential file stage
Code: Select all
OracleStage1------------>Funnel----->RemoveDuplicates----->Copy----->SequentialFile
^
|
|
|
Oraclestage2
We are storing this data in sequential file as it is an input for a jar file which we are calling in after job subroutine.Data in sequential file
Col1||Col2||Col3||Col4
rec1||abd||def||ghi
rec2||abc
asd||kol||llp
rec3||jghg||jghr||kjgng
Can anyone please tell me how can we replace this newline character with come combination of characters like ';:;:;:'.
we dont have any transformer stage in the job and we wanted to do this without using the transformer stage.
any help is highly appreciated.
thanks.