o. Edit the filter expression to have
SRC_CUSTOMER.CUSTID < 105. Scroll down and ensure that the Source
option from the Execute on panel is selected.
p. Click the Flow tab. Click SrcSet1 (FILE_GENERIC). In the Source Set Properties,select LKM File to SQL.
q. In the Flow tab, click the Target datastore. In the Target Properties panel, set the option DELETE_ALL to the value “true” as shown next. Click the Save button to save
the interface.
Note: By setting “DELETE_ALL” to “true”, you ensure that the table is cleared before you populate it with new data.
2. Run this interface, and check the content of the TRG_CUSTOMER table.
a. In the Projects tab, select interface INT_9-1. Click the Execute button
.
b. Click OK in the Execution window, and then click OK when the “Session started” message appears. Open Operator, and verify that your Interface executed successfully.
Note: In ODI Operator Navigator, you may need to click the Refresh icon
c. Return to Designer, click the Mapping tab, and select the TRG_CUSTOMER target datastore (click the name of the datastore). Right-click and select the Data option. A window appears with the loaded data.
d. Close this window, and then close your interface.
p. Click the Flow tab. Click SrcSet1 (FILE_GENERIC). In the Source Set Properties,select LKM File to SQL.
q. In the Flow tab, click the Target datastore. In the Target Properties panel, set the option DELETE_ALL to the value “true” as shown next. Click the Save button to save
the interface.
Note: By setting “DELETE_ALL” to “true”, you ensure that the table is cleared before you populate it with new data.
2. Run this interface, and check the content of the TRG_CUSTOMER table.
a. In the Projects tab, select interface INT_9-1. Click the Execute button
.b. Click OK in the Execution window, and then click OK when the “Session started” message appears. Open Operator, and verify that your Interface executed successfully.
Note: In ODI Operator Navigator, you may need to click the Refresh icon
c. Return to Designer, click the Mapping tab, and select the TRG_CUSTOMER target datastore (click the name of the datastore). Right-click and select the Data option. A window appears with the loaded data.
d. Close this window, and then close your interface.
No comments:
Post a Comment