Hi,
I am trying to encode data from flatfile and then to decode the encoded data to original form.
Procedures that I followed:-
1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle)
2. To decode this back I used AES_DECRYPT(A_ID,'abd').
But after executing the workflow, I am not getting any data in output.
can anybody tell me how to decrypt the encoded data back to original form ??
- 0 Answers
- 1232 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Is the company liable to deduct professional tax of directors?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
Difference between Bookmark lookup & RID lookup?
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?
today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
What severity level errors are managed in TRY-CATCH block?
How to view the error log for any specific instance?
What is live lock, deadlock and what is Lock escalation?
When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.
definion of tcp
Oracle Errors 
