h. In the Expression Editor, select the AGE_RANGE
column and drag it into the expression window. Verify that your
expression is LKUP_AGE_RANGE.AGE_RANGE. Click OK to close the Expression
Editor.
i. To verify the SQL expression, click the Check the expression in DBMS icon
, and then click OK. Click the Flow tab.
j. In the Flow tab, click the Target area and ensure that IKM Selector is set to IKM Oracle Incremental Update. Save the interface INT_9-2.
k. In the Designer Projects tab, select INT_9-2, and then click the
icon to execute your interface. Select the Simulation check box, and then click OK.
l. In the Simulation window, scroll down to view the generated code for your lookup, and then click Close.
2. Run interface INT_9-2 and view the lookup data.
a. Click the Execute button again to run your interface
. Click OK. Click OK again.
Note: Do not select the Simulation check box.
b. Click the Operator tab and verify that your interface INT_9-2 successfully executed.
c. Double-click (SRCSet1 - Load data), and then click the Code tab. View the code on the source and
d. Switch from the Operator Navigator to the Designer Navigator in the Projects tab, and open the INT_9-2 interface if it is not still open. Click the interface’s Mapping tab.Right-click Target Datastore – TRG_CUSTOMER, and then select the Data option. View your lookup data. Close the Data Editor window. Verify that your interface is saved and the close the tabs.
i. To verify the SQL expression, click the Check the expression in DBMS icon
, and then click OK. Click the Flow tab.j. In the Flow tab, click the Target area and ensure that IKM Selector is set to IKM Oracle Incremental Update. Save the interface INT_9-2.
k. In the Designer Projects tab, select INT_9-2, and then click the
icon to execute your interface. Select the Simulation check box, and then click OK. l. In the Simulation window, scroll down to view the generated code for your lookup, and then click Close.
2. Run interface INT_9-2 and view the lookup data.
a. Click the Execute button again to run your interface
. Click OK. Click OK again.Note: Do not select the Simulation check box.
b. Click the Operator tab and verify that your interface INT_9-2 successfully executed.
c. Double-click (SRCSet1 - Load data), and then click the Code tab. View the code on the source and
d. Switch from the Operator Navigator to the Designer Navigator in the Projects tab, and open the INT_9-2 interface if it is not still open. Click the interface’s Mapping tab.Right-click Target Datastore – TRG_CUSTOMER, and then select the Data option. View your lookup data. Close the Data Editor window. Verify that your interface is saved and the close the tabs.
No comments:
Post a Comment