In order to mask data I am using REMAP_DATA parameter in Oracle datapump as follows:
expdp \'/ as sysdba\' DIRECTORY=DUMP_DIR DUMPFILE=dumpfile.dmp LOGFILE=logfile.log SCHEMAS=user0 REMAP_DATA=user0.table1.col1:user0.pckg_mask.fun_mask REMAP_DATA=user0.table2.col2:user0.pckg_mask.fun_mask REMAP_DATA=user0.table1.col3:user0.pckg_mask.fun_mask
This is just an example. Instead of creating and deploying individual functions for different columns I am using fucnction overload method hence using the same function name but with different input parameter datatype.
But some columns need special logic for masking and the logic is stored in a central table.
So, is it possible that I can know which column is being processed by datapump and from which column it will take export next? (So that I can deploy the logic at run-time for that column which is being exported currently)
The question might be vague or complicated. Please do ask for needed information or any suggestion for improving question quality.
