how to know the Last (nth) Data Package in ODS start routine
In the start routine, for each record loaded in the ODS, i will match if it has an entry in TABLE1. If there's a match, i will set the match indicator in of the record in TABLE1 as 'Y'. After that, all records that doesn't have a match ( no indicator 'Y' ) will be appended to DATA_PACKAGE.
The problem is the data coming to the ODS comes in several data packages. So i dont want to append data yet in DATA_PACKAGE unless all the matching has been done for all records. Or, i won't append any data until i am finish with the last record or last data package.
How will i know the number of data packages for each load request? Or is it possible to know in the start routine what is my (nth) last data package?
Any ideas will be appreciated.