Ensure that both the source and destination tables have a primary key present.
The first three points above can be found in the relevant articles in my blog. One, Preparing1.1 source SQL statementSELECT a.ID, a.ORG_ID, a.NAME_ID, a.EVR_ID, a.PACKAGE_ARCH_ID, a.PACKAGE_GROUP, a.RPM_VERSION, a.DESCRIPTION, a.SUMMARY, a.PACKAGE_SIZE, a.PAYLOAD_SIZE, a.INSTALLED_SIZE, a.BUILD_HOST, a.BUILD_TIME, a.SOURCE_RPM_ID, a.CHECKSUM_ID, a.VENDOR, a.PAYLOAD_FORMAT, a.COMPAT, a.PATH, a.HEADER_SIG, a.COPYRIGHT, a.COOKIE, a.LAST_MODIFIED, a.CREATED, a.MODIFIED, a.HEADER_START, a.HEADER_ENDFROM rhnpackage a LEFT JOIN web_customer b ON a.org_id = b.IDWHERE a.name_id > 5 AND a.package_group = 4;
1.2 Creating mappings
Push the related tables in the model target database to the Map box and set up the related connections. As shown in the following:
1.2.1 Setting up joinsIn the logical structure of the map, click the connection icon, in Condition, enter "Join Condition" and "Join Type" and click Save. As shown in the following:
1.2.2 Setting FilterIn the logical structure of the map, click the filter icon, in Condition, enter "Filter Condition", click Save. As shown in the following:
1.2.3 Setting the target table consolidation typeIn the logical structure of the map, click on the target table, set "target" of "integration Type" as "Incremental Update", click Save. As shown in the following:
1.2.4 Set the Knowledge module for the target groupIn the physical structure of the mapping, the Knowledge module for setting up the AP is "LKM SQL to SQL (built-in)." GLOBAL ", click Save. As shown in the following:
In the physical structure of the shot, set the knowledge module of the target table to "IKM Oracle Incremental Update" and click Save. As shown in the following:
1.3 Validating mappingsClick on "√" to verify it as shown in:
Second, Scheduling2.1 generation sceneRight-click on "Map Name" and select "Generate Scenario ..." as shown in:
The scene name and version number are customized as shown in:
2.2 Scheduled Task settingsExpand the scene, right-click scheduling, select "New scheduling", and define the automatic scheduling time according to the actual situation. This is the day of the afternoon 16:00 start to run. Such as:
Finally, update the agent's scheduling information to see the job information that is about to run, as shown in: