How to do data masking for xmldatatype(oracle database) in informatica

226 views Asked by At

I have oracle table with xml type column with xml data,that xml data has some elements which needs to be masked such as phonenumber, data of birth, firstname and lastname etc.. using informatica. Currently I have been following below approach. Tried exporting xml data into xml files and masked using xml transformation using informatica and updated those xml columns using update quires manually. Is there any way to read the xml data directly from oracle xml type column and apply mapplet and load it into target table or any other generic approach to achieve this solution ?

1

There are 1 answers

4
Maciejg On

It should be possible to do exactly as you describe. Read data from Oracle, pass the xml data through a Mapplet that will use XML parser, do the masking and will use XML Generator to put data back alltogeher into single column.

Mapping:

Source--xml_column-->Mapplet----\
      \----->all_other_columns---->Joiner-->Target

Mapplet:

Input_coulmn-->XML parser-->Exp_Masking-->XML Generator-->Output

What have you tried and what errors did you encounter?