How can i skip or eliminate extra blank records in a file in oracle integration ?

sai krishna2815

How can i skip or eliminate extra blank records in a file in oracle integration , when i try to read the file it is erroring out due to the blank records at the end . It is not consistent some times if the file is not having blank records it is processing well. It is erroring only when the file has blank records at the end .

Process I am doing in the integration is first downloading the file and the read the file from the location using stage concept.

Thanks

Sai

Adrian_Popescu-Oracle

Hi,

You can create a Jython procedure in ODI to remove the empty lines, prior to executing the mapping.

Adrian