Is it possible to use transformation to ignore DELETE using wildcard but exclude some tables from it within the same schema? Taking it further, is it possible to do this for other DML like INSERT or UPDATE.
Transformation can be used to ignore some types of DML like DELETE by directing Post to use PL/SQL routine when encountering a particular type of DML, like DELETE in our case. It is also possible to use wildcard to do this for a particular schema or a particular group of tables. If one wants to ignore a DML, say DELETE, for all but a few of the tables in schema, the following illustration can be used as a guideline to accomplish this:
Shareplex Administrator Guide Chapter “SharePlex Optional Setup” section “Using transformation with SharePlex” section delves on this the excerpt is pasted after some modifications to illustrate our point:
If a transformation routine is specified for an individual table, such as for scott.emp in the following example, and the table also is part of a group of tables for which another routine is specified, only the table-specific routine is used for that table when the associated DML operation occurs.
In the example, only scott_transformation_delete is used for DELETEs on scott.emp, but scott_transformation_all is used for UPDATEs and INSERTs to scott.emp. For all other tables in the scott schema, the scott. transformation_all routine is used for all DML statements:
TABLE Procedure
scott.* scott_transformation_all
scott.emp scott_transformation_delete
