DSXchange

I have a requirement to Unzip multiple files in a directory.

files can be of the type PDF or JPEG or txt or csv.

The count of files in a directory on daily basis may vary and also size of the files may be huge ( hold million of records).


Which is best to use Datastage or Unix Shell script ?

need experts opinion on this...

I would like to know the options available in Datastage

Write a script and let DataStage execute it.

You mean say that the efficient way is to write a UNIX shell script and execute through DataStage

Unzip is unzip. Assuming you have to loop through multiple files you need a script and there's no reason to not let DataStage schedule/run/monitor that. If it's just one file, skip the script.

Meaning an Execute Command stage in a Sequence job or a Before Job ExecSH in the job that will be loading them.