ODI TOOLS - ODIZIP AND ODIFILEDELETE

Scenario:

Everyday we will get three files (i.e., *_sysdate.csv) we need to load those files and then we need to zip those files and place in one specified folder after that we need to remove from source directory.

Procedure:

Step 1:
Upto loading those files, steps are explained in my previous post

Step 2:

• Create a new package
• Create a variable and go to refresh tab provide "SELECT TO_CHAR(SYSDATE,'DD_MM_YYYY') FROM DUAL" and select appropriate logical schema
• Drag and drop variable two times -- Select first variable as declare and second variable as refresh variable.
• Drag and drop procedure
• Drag and drop ODIZip and ODIFileDelete from package toolbox

Step 3:

• Select ODIZip Tool in the package and enter following details
• SourceFileDirectory : <Directory Location>\*#<PROJECT_NAME>.<VARIABLE_NAME>.csv
• ZIP File : <ZIP File Directory Location>\#<PROJECT_NAME>.<VARIABLE_NAME>.ZIP and leave remaining as it

Step 4:

• Select ODIFileDelete tool in the package and enter following details
• Directory: <Directory Location> and FileName : *#<PROJECT_NAME>.<VARIABLE_NAME>.csv and leave remaining as it

Step 5:

     Connect all the components in sequencial order variable_declare--variable_refresh--procedure--ODIZip--ODIFileDelete

Completed Successfully!!!