Hi,
I am using expdp to extract & Mask data using REMAP_DATA option as shown below.
TABLES=SUPDBA.TDM_TABLE
LOGFILE=exp_log_01.log
DUMPFILE=exp_dump_01.dmp
CONTENT=DATA_ONLY
DIRECTORY=TDM_TEST_DIR
REMAP_DATA=SUPDBA.TDM_TABLE.First_name:TDM_PACKAGE_001.MASK_NAME
Function Definition
FUNCTION MASK_NAME(p_name in VARCHAR2) return VARCHAR2
IS
BEGIN
IF p\_name is null THEN
Return NULL;
ELSE
RETURN 'Dummy name';
END IF;
END;
When the function is called for each record in the table, the FIRST_NAME field value is passed to the function. No other column value is passed.
I would like to know if there is any way to pass other columns to the function in addition to the field being masked. I need to implement a Lookup/Replace functionality in the Function. I have to a pass Customer_no, First_name fields to the function. In side the function, I will use a different table LOOKUP_TABLE which gives the masked name field.
My question is, with REMAP_DATA option, is there any way to pass more than one parameter to the function, something like this :
**REMAP_DATA=SUPDBA.TDM_TABLE.First_name:TDM_PACKAGE_001.MASK_NAME(Customer_No, First_name)
**
Thanks for your time.
Ravi