i need to compare header value with no of records in the Detail file. i need to abort the flow if it doesnt matches. if i use sequential stage as the input and a compare stage for comparing the values, it works fine. if i use one as complex flat file(for header stage, since it is mainfram file), then there comes an error
Code: Select all
Compare_22,0: On partition [0], the first dataset had 0 records and the second dataset had 1 records.
i thought the problem may be with partition, so i made to run in sequential mode, still it continues
Note:Header record is read by CFF which has only one record so i made Read First n rows = 1 under File option tab.
Can anybody help me out