0 Replies Latest reply: Sep 12, 2011 7:39 AM by 874799 RSS

    ODI Batch processing Source is XML and target Oracle DB

    874799
      Hi,

      My source is XML file and target is Oracle DB.
      Here I have two scenarios for batch processing:

      1st --
      Source XML is huge say it has 1000 records and here I need to break it into chunk of 100 record batches and update db.
      So 10 times data should be inserted into db (10 batches each batch of 100 records).
      But this should be done using a single interface or package.


      2nd --
      Source XML files are small say each have 10 records but there are 100 such XML files.
      In this case I need to merge every 10 of XML files data into one batch data and update db.
      So here again 10 times data should be inserted into db (10 batches each batch of 100 records).
      Again this should be done using a single interface or package.

      My doubt is whether both scenarios can be achieved in ODI.
      If so are there any links or pointers you can provide me which deals with such scenarios.

      Thanks.