在将数据装载到SQLServer数据库之后,可以使用 SQL执行转换和装载结果表。
Once the data is in the SQL Server database, SQL can be used to perform the translation and load the result table.
MDI技术还包括企业应用程序集成(EAI)、企业信息集成(EII)以及提取、转换和装载(etl)技术。
The MDI technologies also include a set of enterprise application integration (EAI), enterprise information integration (EII), and extract, transform, and load (ETL) technologies.
典型的数据集成架构把来自各个源系统的数据提取、转换和装载(etl)到数据仓库、数据集市和多维数据集中。
A typical data integration architecture involves data from various source systems being extracted, transformed, and loaded (ETL) into data warehouses, marts, and cubes.
ETL服务支持从一个或多个源系统提取、转换和装载数据,从而满足一个或多个目标系统(比如数据仓库或MDM系统)的需要。
ETL services support the initial and incremental extract, transform, and load of data from one or more source systems to meet the needs of one or more targets, such as a data Warehouse and MDM system.
本文描述的场景使用DB2pureXML中存储的操作型数据作为提取、转换和装载(ETL)任务的输入, 这些任务用于填充一个基于DB2 的数据仓库。
The scenario described in this article uses operational data stored in DB2 pureXML as input to the extract, transform, and load (ETL) job that you'll design to populate a DB2-based data warehouse.
在这个部分完成并经过测试之后,本文将带领您改进该作业,以提取和转换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.
不过,具备数据仓库、ETL(提取-转换-装载)技术和XML知识对理解本系列文章有帮助。
However, prior knowledge of data warehousing, ETL (extract-transform-load) technology, and XML will help when reading this article series.
尤其是初始的步骤,它们将指导您创建整个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.
该公司的装载机可以处理多种尺寸的产品,交换零件和调整最少,转换可以在5分钟内完成。
Our Loaders can handle multiple size products with minimal change parts or adjustments allowing changeovers to be completed in less than 5 minutes.
一旦你装载数据库,数据库服务器自动识别卸载文件的字节类型,在加载数据库和联机数据库时执行所有需要的转换。
Once you load the database, Adaptive Server automatically identifies the endian type on the dump file and performs all necessary conversions during the load database and online database.
现在忽略了对XML的无效字符,允许装载即使经过格式转换和网络旅游项目和文件。
Invalid characters for XML are now ignored, allowing loading the project and files even after format transformations and network travel.
现在忽略了对XML的无效字符,允许装载即使经过格式转换和网络旅游项目和文件。
Invalid characters for XML are now ignored, allowing loading the project and files even after format transformations and network travel.
应用推荐