Integrate 1 source table to 2 target tables in same target schema for same chann

Viewing 1 post (of 1 total)
  • Author
  • #8743
    Herman Verheul

    If it’s needed to integrate source table called district to target tables district and district2, in the same target schema, using one channel, the following steps can be executed to achieve this;

    Copy table called district to district2 in the HVRGUI, so now there are 2 entries in the HVR catalog for the same source table.

    This is important for refresh, because refresh will use, if create absent table with key is chosen, this name to create an index with __x0 suffix, so the index name would be district2__x0. If the table was not copied with a different name, and the original district table already existed in the same target schema with index name district__x0 the following error would happen;

    F_JD2272: DBMS error [ORA-00955: name is already used by an existing object]

    For table district2 add action \TableProperties /Basename=district2,group= “target group”

    This will make sure the integrate job will integrate changes coming from source table district, into target table called district2.

    Download a screenshot example of the above actions here.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us