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.