j. To test your interface, click the Execute button . The following screen appears. Retain the defaults and click OK. On the next screen, click OK.
k. Open ODI Operator and verify that your interface was executed successfully. In
Operator, click Session List tab, select All Executions, and the then click the refresh
button . View the execution results for the interface INT-EXP-FF-RT.
l. Double-click Step 12 and click the Execution tab. View the number of rows inserted
into the target table (16).
10. Use the Quick Edit feature to enable filtering rows with Sales_Person_ID > 30. In addition,
you capitalize the first letter of each last name and first name, leaving the other characters
in lowercase.
a. In the INT-EXP-FF-RT tab, select Quick-Edit tab, expand Filters section, and then click
Add Filters icon.
b. Select SALES_PERSON_ID row, and then click Expression Editor icon . In the left
panel of Expression Editor, double-click SALES_PERSON_ID. Edit the expression to
read: SRC.SALES_PERSON_ID > 30. Click OK. For Execution Location, select
Staging. Click OK.
c. Scroll down and expand the Mappings section. In Mappings, click the Ltrim(First_name) column , and then select the Expression Editor icon. In functions, expand Strings, and then double-click the INITCAP function. Edit the expression to
read: INITCAP(Ltrim(SRC.FIRST_NAME)). Click OK.
d. Repeat the previous step for the column LAST_NAME. Your result is shown in the
following screen. Click the Mapping tab and save your interface .
11. Execute your modified interface and verify the result.
a. In Designer execute your interface . Click OK. Click OK again
b. Open ODI Operator and verify that the interface executed successfully. Open step 8 –Integration. Click the Code tab, and view your modifications.
c. Click the INT_EXP_FF_RT tab. In the Mapping tab, right-click the target datastore and select Data. View the filtered rows (SALES_PERSON_ID > 30) inserted in the table.Close your Data Editor and the tabs.
k. Open ODI Operator and verify that your interface was executed successfully. In
Operator, click Session List tab, select All Executions, and the then click the refresh
button . View the execution results for the interface INT-EXP-FF-RT.
l. Double-click Step 12 and click the Execution tab. View the number of rows inserted
into the target table (16).
10. Use the Quick Edit feature to enable filtering rows with Sales_Person_ID > 30. In addition,
you capitalize the first letter of each last name and first name, leaving the other characters
in lowercase.
a. In the INT-EXP-FF-RT tab, select Quick-Edit tab, expand Filters section, and then click
Add Filters icon.
b. Select SALES_PERSON_ID row, and then click Expression Editor icon . In the left
panel of Expression Editor, double-click SALES_PERSON_ID. Edit the expression to
read: SRC.SALES_PERSON_ID > 30. Click OK. For Execution Location, select
Staging. Click OK.
c. Scroll down and expand the Mappings section. In Mappings, click the Ltrim(First_name) column , and then select the Expression Editor icon. In functions, expand Strings, and then double-click the INITCAP function. Edit the expression to
read: INITCAP(Ltrim(SRC.FIRST_NAME)). Click OK.
d. Repeat the previous step for the column LAST_NAME. Your result is shown in the
following screen. Click the Mapping tab and save your interface .
11. Execute your modified interface and verify the result.
a. In Designer execute your interface . Click OK. Click OK again
b. Open ODI Operator and verify that the interface executed successfully. Open step 8 –Integration. Click the Code tab, and view your modifications.
c. Click the INT_EXP_FF_RT tab. In the Mapping tab, right-click the target datastore and select Data. View the filtered rows (SALES_PERSON_ID > 30) inserted in the table.Close your Data Editor and the tabs.
No comments:
Post a Comment