This content has been marked as final. Show 3 replies
you can think creating views/materialized views to mask your sensitive columns..in a table..1 person found this helpful
The developer would only be able to see data in tables from a development work repository. Ideally, the data within a development environment would be scrubbed of any personal/confidential data, or, better still, be test-generated data which isn't confidential at all.
In testing/production environments (containing sensitive information) you can utilise execution-only work repositories which only present the user with information relating to the execution of ODI components.
Thanks for the quick responses....
I told my client earlier today that data in their dev environments should be scrubbed as part of their post refresh process.
I'm new to ODI so the Execution-Only work repositories are new to me. :) I will need to read a bit more about it but I should be able to ease their minds a bit.