所以,这里装载表定义“CHENLI . S_CUST”作为这个聚合器的输入。
So load the table definition "CHENLI.S_CUST" as input of this aggregator.
不要通过重新装载表定义覆盖db 2stage中的输入列,否则前面X ML输入stage中的XPath将丢失。
DO NOT override the input columns in DB2 stages by reloading table definitions, otherwise the XPath in the foregoing XML input stage will be lost.
可以导入和导出静态的关系数据,这简化了装载关系表的过程。
You can import and export static relationship data, simplifying the process of loading the relationship tables.
在这个部分完成并经过测试之后,本文将带领您改进该作业,以提取和转换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.
您可以用类似的方式装载用于其他事件类型的表。
You can load the tables for the other event types in a similar way.
只要有可能,应该在初次装载一个表之前创建其所有索引,因为LOAD实用程序建立索引的效率比CREATEINDEX过程要高。
Whenever possible, create all indexes on a table before initially loading it, since the load utility builds indexes more efficiently than the create index process.
在采用默认行为时,用户必须对进行装载的每个表空间进行备份。
With the default behavior, the user is forced to take backups of each tablespace that was loaded into.
如果成功执行这个数据流,就会调用第二个数据流,它装载目标DWADMIN . holdings表。
Successful execution of this data flow causes the second data flow to be invoked, which loads the target DWADMIN.HOLDINGS table.
清单4中显示的过程带有必要的输入参数——文件的名称和类型,以及文件中的数据所装载到的目标表的全限定名称。
The procedure shown in Listing 4 takes the necessary input parameters — the name and type of the file and the fully qualified name of the table into which the data from the file is to be loaded.
适合的场景:连接和浏览derby或DB 2数据库,创建模式对象,运行和创建sql脚本,装载和卸载表,以及从derby到db2的迁移。
Intended use cases: Connecting to and browsing Derby or DB2 databases, creating schema objects, running and creating SQL scripts, loading and unloading tables, and Derby to DB2 migration.
下面给出了关于装载大型表的其他建议。
Additional recommendations for loading large tables are as follows.
然后,从XML表定义装载名称空间(类似于图16 显示的那样)。
Second, load namespaces from the XML table definition (similar to that shown in Figure 16).
下面的例子演示了如何在4个目标数据库服务器上实现模板、创建表以及装载数据?
The following example illustrates realizing the template, creating the tables, and loading data on four target database servers.
再举一个例子:IT运营经理接到通知,一个装载事实表的ETL作业在处理准备阶段DB 2 _ Input_Facts中读取输入时失败了。
In another example, the it Operational Manager has been notified that an ETL job for loading the fact table has been aborted when reading its input in the processing stage DB2_Input_Facts.
虚表还可以用于装载TimeSeries数据。
Virtual tables can also be used for loading TimeSeries data.
为了完成这个场景,您需要从XMLinput源提取适当的数据,并将其装载到DWADMIN. holdings表。
To complete the scenario, you need to extract the appropriate information from the XML Input source and load this data into the DWADMIN.HOLDINGS table.
为DWADMIN . holdings表装载信息。
接下来,您将定制Transformer阶段,以在将数据装载到目标表之前根据需要修改它。
Next, you'll customize the Transformer stage so that the data will be modified as needed before it's loaded into the target table.
装载xml表定义“target _ xml”之后,xml输出stage如图18所示。
After loading the XML table definition "target_xml," the XML output stage is shown as illustrated Figure 18.
对于这个stage,使用导入的CHENLI . s_contact表定义来装载列。
Here, use the imported CHENLI.S_CONTACT table definition to load the columns for this stage.
刷新表:在某些数据仓库中,整个表每年删除一次,然后装载一个替代的表,这个新表包含了除不再需要的数据以外的所有数据。
Refresh table: In some data warehouses, the entire table is dropped once per year and a replacement table is loaded with all the data except for the data that is no longer needed.
在测试数据库中定义了所有表之后,现在可以装载测试数据。
With all the tables defined in the test database, you can now load test data.
将审计数据装载到表中有很多好处。
监视过程完成之后,您刷新审计缓冲区,将审计记录提取到定界ASCII文件,然后将这些文件装载到db2表中。
After the monitoring period finished, you flushed the audit buffer, extracted the audit records into delimited ASCII files, then loaded the files into DB2 tables.
可以每晚将这个表装载到仓库中,或者每当有新的病人来医院,并且有必要的度量指标时实时地将这个表装载到仓库中。
This table could be loaded into the warehouse each night, or in real-time, whenever a new patient has arrived at the hospital, and once the necessary measures are available.
这个流装载客户表,将它传递到偏差检测算法,并将结果写到一个新表中(如图3所示)。
This flow simply loads the customer table, passes it to the deviation detection algorithm, and writes the results into a new table (see Figure 3).
测试该过程的第一步是准备一个可以装载到一个表中的文件。
The first step in testing the procedure is to prepare a file that can be loaded in a table.
当处理大量的数据时,一开始将数据装载到表中时可能会遇到性能问题。
When dealing with large amounts of data, the initial loading of the data into the table can present some performance challenges.
名称空间声明的装载类似于从表定义中装载列——从xml表定义中装载名称空间。
Loading namespaces declaration is similar to loading columns from a table definition — it loads namespaces from the XML table definition.
将审计记录提取到定界ASCII文件之后,就可以将ASCII文件的内容装载到db2表中。
Once you have extracted the audit records into delimited ASCII files, you can load the contents of the ASCII files into DB2 tables.
应用推荐