View Name | Description |
CompositeView | This view provides a unified, composite view of other views, ViewOrder, ViewSales, and ViewSupplier. It examines the three separate views and joins them on the ProductID column. |
ViewOrder | This view provides a specific view of the ds_orders data source and retrieves details about orders and customers. It examines three tables from the ds_orders data source, and joins the tables on two columns, CustomerID and OrderID. Then, it selects specific columns for the result set. |
ViewSales | This view provides a combined view of a relational data source (ds_orders) and an XML-type of file data source (productCatalog.xml). The view examines the orderdetails table from ds_inventory and the entire productCatelog_xform, and joins them on one column, ProductID. Then, it selects specific columns for projection in the execution result set. |
ViewSupplier | This view provides a specific view of the ds_inventory data source and retrieves information about inventory and suppliers. It examines three tables from the ds_inventory data source, and joins the tables on two columns, PurchaseOrderID and SupplierID. Then, it selects specific columns for the result set. |