something simple (or not):
Is there a way to mask a field based upon the value of another field that was just masked in the same column map?
We have three fields FIRSTNAME, LASTNAME, FULLNAME.
The column map uses HASH_LOOKUP on FIRST and LAST. Those results need to be placed into the FULLNAME field.
I can only think of 2 pass conversion.
step 1: Convert first and last name fields
step 2: Concatenate FULLNAME field (FULLNAME = FIRSTNAME || ' ' || LASTNAME
I tried a column map procedure but that holds onto the original names
OPTIM 9.1 fp3
Windows 2008 R2
Oracle data source