Unzip multiple files- DataStage versus UNIX Shell Script

suja.somu · Post by **suja.somu** » Thu Feb 13, 2014 8:42 am

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

chulett · Post by **chulett** » Thu Feb 13, 2014 8:52 am

Write a script and let DataStage execute it.

suja.somu · Post by **suja.somu** » Thu Feb 13, 2014 8:54 am

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

chulett · Post by **chulett** » Thu Feb 13, 2014 8:57 am

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.

chulett · Post by **chulett** » Thu Feb 13, 2014 10:22 am

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