然后,从lineitem表中提取关于订单中尚未发货的各行项目的信息。
Information on individual line items that make up the orders, but are as yet unshipped, is then extracted from the LINEITEM table.
OrderPriority作业首先提取'Building '市场客户的客户键,然后从ORDERS表中提取关于他们所下的订单的信息。
The OrderPriority job first extracts the customer keys for those customers who are in the 'Building' market segment, and then extracts information about orders placed by them from the orders table.
因为采购订单不包含详细产品信息,所以需要进行单独查询,以便从产品表中查找产品详细信息。
Since the purchase order contains no detailed product information, a separate query is needed to find the product details from the product table.
购买订单的一部分信息分解到关系副表中,用于建立间接索引。
Part of the purchase order information is shredded into relational side tables for indirect indexing.
对于抓取数据也是一样;每当从order_items表抓取数据时,还需要获取订单信息,因此还要访问order表。
The same is true for retrieving data; every time you retrieve data from the ORDER_ITEMS table, you also want to get the order information, so order table will be accessed too.
在采购订单和产品表之间创建联接以获取产品详细信息。
Create a join between the purchase order and the product table to get product details.
例如,假设有两个分别包含产品信息和销售信息的表,您可以使用联接操作来匹配同一销售订单的销售信息和产品。
For example, given two tables that contain product information and sales information, you could use a join operation to match sales information and products for the same sales order.
例如,假设有两个分别包含产品信息和销售信息的表,您可以使用联接操作来匹配同一销售订单的销售信息和产品。
For example, given two tables that contain product information and sales information, you could use a join operation to match sales information and products for the same sales order.
应用推荐