l. In the Source area, expand the
lookup datastore. Drag the FIRST_NAME column from the lookup table to the
Target area. In the Target area, click the FIRST_NAME column.
Start the Expression editor
, and then drag the LAST_NAME column from the left
panel of the Expression Editor to the “expression" area.
Start the Expression editor
, and then drag the LAST_NAME column from the left
panel of the Expression Editor to the “expression" area.
m. Edit the expression to read LK_UP_SRC_CUSTOMER.FIRST_NAME | | ‘ ‘ ||
LK_UP_SRC_CUSTOMER.LAST_NAME, as shown next. Click OK. Click the
button to validate the expression.
LK_UP_SRC_CUSTOMER.LAST_NAME, as shown next. Click OK. Click the
button to validate the expression.
n. Scroll down, and in the Target Column Properties, rename this column CUST_NAME.
o. Drag the column QTY from the SRC_ORDER_LINES source datastore to the Target area. Edit the mapping expression to read SUM(SRC_ORDER_LINES.QTY).
p. Drag the column AMOUNT from the SRC_ORDER_LINES source datastore to the Target area. Edit the mapping expression to read AVG(SRC_ORDER_LINES.AMOUNT).In the Target Column Properties, rename this column AVG_AMOUNT.
No comments:
Post a Comment