DSXchange

Hi

I have requirement to load files which have been encrypted by third party applications and Keys will be provided to ETL Team. So using those keys, Datastage need to read the data from file and load into table.

Is it possible in Datastage at all?

Sure, if you can decrypt to standard out the Sequential File stage can read that input stream. Leverage the decryption tool in the Filter property of the stage so that it is not at rest in an unencrypted form.