Page 1 of 1
Encryption and Decryption of fields using Datastage.
Posted: Sun Jul 17, 2011 9:10 pm
by kollurianu
Hi All,
Just want to encrypt only 2 fields (not the whole file) in a file and also should be able to decrypt those 2 fields in Datastage .
Any inputs , greatly appreciated.
Thanks in advance.
Posted: Sun Jul 17, 2011 9:32 pm
by pandeesh
I don't think there is an in built encryption and decryption mechanisms available in datastage.
But you can have your own routine for that with your own logic.
Posted: Mon Jul 18, 2011 2:11 pm
by kollurianu
Thanks Pandeesh for your response.
Anyways to acheive this other than creating a custom PX routine for it?
Any inputs greatly appreciated..
Posted: Mon Jul 18, 2011 7:47 pm
by jwiles
You could always call an external filter, BuildOp or custom operator.
As Pandeesh has indicated, there's not really anything built-in to the parallel engine at this time to do this.
Regards,
Posted: Mon Jul 18, 2011 7:57 pm
by pandeesh
kollurianu wrote:Anyways to acheive this other than creating a custom PX routine for it?
There are ways.. right now, i am building a basic server routine for encryption with SEQ() and CHAR() functions.
You can refer this post:
viewtopic.php?p=400900