在这个部分完成并经过测试之后,本文将带领您改进该作业,以提取和转换XML数据,然后将其装载到DWADMIN . holdings表。
Once this portion is complete and tested, the article guides you through enhancing the job to extract, transform, and load XML data into the DWADMIN.HOLDINGS table.
尤其是初始的步骤,它们将指导您创建整个DataStage作业的一部分,该部分提取和转换数据,并将数据装载到DWADMIN . acct表。
In particular, the initial steps guide you through creating a portion of the overall DataStage job that extracts, transforms, and loads data into the DWADMIN.ACCT table.
在DataStage作业上,本阶段生成从内部sap表读取数据的ABAP代码并发送此数据到接收abap提取阶段。
This stage generates ABAP code that reads data from internal SAP tables and sends that data to the receiving ABAP extract stage in a DataStage job.
本节将使用一个示例ETL作业来演示从名称为Orders的teradata表中提取数据的步骤。
This section USES a sample ETL job to illustrate the steps to extract data from the Teradata table named Orders.
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.
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.
应用推荐