This section shows an example of an XML Source Qualifier transformation in a mapping. The example uses an XML file containing store, product, and sales information.

The following figure shows the StoreInfo.xml file:

You might want to calculate the total YTD sales for each product in the XML file regardless of region. Besides sales, you also want the names and prices of each product.

To do this, you need both product and sales information in the same transformation. However, when you import the StoreInfo.xml file, the Designer creates separate groups for products and sales by default.

The following figure shows the default groups for the StoreInfo file with the product and sales information in separate groups:

Since you cannot link both the Product and the Sales groups to the same single input group transformation, you can create the mapping in one of the following ways: