How to ignore posting for a particular object in an Open Target environment.
The Open Target environment allows for disabling posting on particular objects, just as it is done in an Oracle target environment. This is all the more handy in such environment as some objects or datatype from the source database may not be supported in a heterogeneous environment involving a different type of target database, say Oracle to SQL server. There are other reasons that may necessitate the use of such feature. The feature allows ignoring one or more objects for posting. To ignore posting on one object on target, you can get the object_id for the object in question from source database configure the parameter on target sp_ctrl as below (note how OPO in case of Oracle target is substituted by OPX in Open Target):
sp_ctrl>set param sp_opx_disable_object_num <object_id from source database for the object to be disabled>
If, at a later time, wishing to undo the above change, carry out the following steps:
sp_ctrl>reset param sp_opx_disable_object_num