1 Reply Latest reply: Jun 28, 2013 8:05 PM by Ayush Ganeriwal-Oracle RSS

    Unzip Multiple Files and Load


      Hi all, i need to unzip several files like named like a.zip, b.zip , c.zip etc. but all have data.csv file with same format in them. Then load them into database. Any suggestions ? Thanks.

        • 1. Re: Unzip Multiple Files and Load
          Ayush Ganeriwal-Oracle

          Perhaps you can do it in following way.

          1. Create a package to accept a zip file name as variable. use this variable to unzip the file in some predefined folder using odiUnzipFile tool.

          2. Add your interface step to load it in the target.

          3. Create a procedure to read the zip file names from a table (populate your file names in a DB table) in the source command and in the target command invoke the scenario for package created in #1 passing the file name.