Can i use unzip session in workflow when the file is a .txt file

Bond 0
Viewed 41

I am working on an Informatica workflow and using Teradata Database. The file is a .txt file. When I run the workflow I get the error message below. Error opening file [/infa_shared/uss/SrcFiles/vnd_MG//PRx]. Operating system error message [no such file or directory]. I have an unzip session in the sessions.

teradata informatica informatica-powercenter
1 Answers

You can always use a command task to execute the unzip explicitly. If your file name is PRx.txt, then the command line of the task will be:

unzip /infa_shared/uss/SrcFiles/vnd_MG//PRx.txt

Then in the next connected session, associate the source file with the filename you have extracted from your .txt archive - in your session's mapping setting.

access_granted0
Related