I am relatively new to ODI and have built several interfaces to do mass data transformation/loads. I now need to do an integration of batch related records whereby a batch header table will get a record written and I will need to process all the related records in a batch detail table, maintaining batch detail running totals for reconciliation to the batch header record once complete. Batches can get written out to the source tables at any time, and multiple batches could show up for processing within milliseconds of each other.
Can anyone recommend a method for triggering the interface whenever a batch header record is written and defining an interface to only run a single batch at a time so reconciliation can be done.
Thanks,
Chris