Adding Loop and Cast Functions
The goal for these steps is to end up with a transform that looks similar to the following:
To add loop and cast operations to your transform
1. Expand the hierarchy of the elements within the productCatelog_xml object.
2. Click the Loop icon. It typically looks like:
3. Click in the Transformation Editor model.
4. Click the handle next to category [1-*] in productCatelog_xml and drag a line across to the source on the left side of the loop object.
5. Click the handle next to product [1-*] in productCatelog_xml and drag a line across to the loop object.
You should now have something similar to:
6. Connect products in the loop operation to outputs in the out operation.
7. Expand category [1-*] and item in the loop operation.
8. Connect the following Loop elements to the following cast operations:
Loop Element | Out Operation Name | Insert Cast |
ProductID | ProductID | |
ProductName | ProductName | Click yes at the popup. |
ProductDescription | ProductDescription | Click yes at the popup. |
SerialNumber | SerialNumber | Click yes at the popup. |
LeadTime | LeadTime | Click yes at the popup. |
CategoryID | CategoryID | |
CategoryName | CategoryName | Click yes at the popup. |
UnitPrice | UnitPrice | |
ReorderLevel | ReorderLevel | |
9. Save and close the transform.
You will query these sources to investigate the issue for ALPHA, to find out why its customer, Landmark Systems, did not receive ALPHA’s product Widget 5 on the date promised (2/10/03). The next step is to build and execute views to obtain specific information about the activities in the Order, Purchase, and Sales departments at ALPHA.
