Remove Trailer record from file during Stage Read Operation
SummaryNeed to remove trailer record which is of different format than other records from txt file using stage read operation (ICS fails with error "Error while reading native data")
I have a requirement where I need to remove the trailer record from a text file at the time of reading it. The trailer record is not of the same format as other records, it has fewer columns. The sample file is attached.
ICS Read operation is failing with error "Error while reading native data.".
Do we have a way where Stage Read operation can read a row with a different format and truncate it?