In the source data structure we have one header record with 8 fields and many detail records with 900 fields each. The target data structure has only detail record with 21 fields. Only one field from source header record and 20 fields from the source detail record will be mapped to the target. Can anybody help me how we could handle the file content conversion for this scenario.
Also, due to the large volume of data if we have to split the file in to smaller packets, how could we retain the header record for all detail records?