Zip file to Oracle DB

veera24 · Post by **veera24** » Wed Mar 07, 2012 1:19 pm

I have a requirement to read a zip file and load in to a BLOB data type field in Oracle DB...Any ideas to do this is really appreciated...

bart12872 · Post by **bart12872** » Mon Mar 12, 2012 11:43 am

We do this, but not using Datastage. With sqlloader it's easy to do that.

veera24 · Post by **veera24** » Mon Mar 12, 2012 11:53 am

Can you tell me how to do that in sqlloader? I do not have idea on it..Thanks...

chulett · Post by **chulett** » Mon Mar 12, 2012 12:38 pm

Can you not leverage something like gunzip to std out in the Filter of the Sequential File stage?