Implementing Changed Data Capture 2

b. Now you need to create one more target datastore to store only changed data. In the Models tab, expand OracleRDBMS1, duplicate the TRG_SALES_PERSON datastore,and rename the copy as TRG_SALES_PERSON_CDC. Save the
TRG_SALES_PERSON_CDC datastore and then close the tab.




c. Open data in the TRG_SALES_PERSON_CDC datastore, and then click the Delete
Current Row icon repeatedly to delete all the rows. Save your changes and close the
tab.




d. In the Projects tab, expand Export-FF-RT > First Folder > Interfaces. Right-click Interfaces, and then select New Interface.

e.In the Interface: NEW window, enter INT_SALES_PERSON_CDC as the name of the interface. Ensure that the Optimization Context is Development. Click the Mapping tab.

f. Open the Models tab. In the tree view, expand the Oracle_RDBMS1 model. Drag the TRG_SALES_PERSON_CDC datastore from the tree view to the Target Datastore zone.
Expand the Oracle_RDBMS2 model and drag the SRC_ SALES_PERSON datastore from the model tree to the Sources zone of your diagram. Click Yes to perform automatic mapping. Save your interface.


g. Right-click the caption of the source datastore and select Data. Scroll down to preview the current source data. Close the Data window.


h. Click the Flow tab, click the Staging Area caption, and verify that the selected IKM is IKM Oracle Incremental Update. Select Distinct Rows.

i. Now you modify this interface to process only the changed data. Click the Mapping tab. Click the source datastore. In the Diagram property panel, select the Journalized Data only check box.

j. To check the new source data set, repeat step d. View your data again. Only the changed data should be visible. Close the data window.

k. Save your interface and close the tab. Execute the interface to process only journalized records.

5. Verify the execution results.
a. Open the Operator. Click Refresh. Expand the All Executions node and verify that your session, INT_SALES_PERSON_CDC, executed successfully.


b. View the data in the TRG-SALES_PERSON_CDC datastore and verify that only three changed rows are inserted in the target datastore.



6. In the Models tab, right-click the SRC_SALES_PERSON datastore and select Drop Journal.
Click OK, and then click OK again. Right-click the SRC_SALES_PERSON datastore again, and then select Remove from CDC. Click Yes to confirm removing the datastore from CDC.