这需要在将来自事务系统的数据加载到数据仓库表中之前,对其进行转换。
This requires that the data from the transactional system be transformed before being loading into the warehouse table.
业务系统收集的结构化源数据 —关于患者、医疗索赔和供应商 —通过提取、转换、加载(ETL)流程输入数据仓库。
Structured source data collected by operational systems—on patients, medical claims, and providers—was fed through extract, transform, load (ETL) processes into the data warehouse.
例如,一些系统以常规调度加载数据仓库执行数据解压。
For example, some systems perform data extracts for data warehouse loading on a regular schedule.
对于我所构建的每个数据仓库,我都以电子表格开始,然后再依据所需加载的历史数据,来填入下一个10 -20年和过去的10 - 20年的天数。
For nearly every data warehouse system I build, I start with a spreadsheet and enter days for the next 10-20 years and the past 10-20 years, depending on how far back data will be loaded.
目前有的很多etl工具,可在将数据加载到数据仓库之前对数据进行提取与转换。
Many ETL tools exist that extract and transform data before loading into the warehouse.
当此表加载到目标数据仓库表customer中,该表位于数据库 stores_demo 中,目标表可能会具有比表 customer_trans更多或者更少的列。
When this table is loaded into the target warehouse table customer, which is in the stores_demo database, the target table might have more or fewer columns than the customer_trans table.
使用splitter功能将数据卸载到预分区文件来为并行加载做准备,轻松地将数据迁移到分区数据库或数据仓库。
Easily migrate data to a partitioned database or warehouse using the splitter function to unload into pre-split files ready for parallel loading.
将数据加载到数据仓库中。
详细而准确的元数据对于数据仓库的创建、数据加载、运行维护、清理脏数据等工作都必不可少。
Detailed and exact metadata is absolutely necessarily for the creation, the data loading, the data cleaning and regular maintenance of a data warehouse.
该数据仓库每周七天每天24小时不间断地运行,持续不断地加载并处理全球销售数据,以供报告之用。
It runs 24 hours a day, seven days a week to continually load and process worldwide sales data to make the data available for reporting.
该数据仓库建立技术包括数据组织体系结构、数据采集、抽取、加载、数据立方体及OLAP功能查询技术。
The techniques of the Data Warehousing includes the system structure of the data organization, the data collecting, data extraction, data loading, data cube and OLAP query technique.
为此,一个常见的做法就是,建立一个数据仓库,然后抽取、转换和加载来自这些不同应用软件的数据,为来自这多个应用软件的数据提供统一视图。
One common way to do this is to build a data warehouse and extract, transform and load data from these diverse applications to deliver a common view of data from across these multiple applications.
数据预处理平台通过数据抽取、数据清洗、数据转换和数据加载等方法整合并转换现有数据资源至数据仓库。
Through data extraction, data cleaning, data conversion and data loading the data pre-processing platform integrate the original data into the data warehouse.
数据获取是获取,集成,转换,清洗,重构和数据加载到数据仓库和ODS系统的一系列的过程。
Data Acquisition is the set of processes that capture, integrate, trans-form, cleanse, reengineer and load source data into the data warehouse and operational data store.
数据获取是获取,集成,转换,清洗,重构和数据加载到数据仓库和ODS系统的一系列的过程。
Data Acquisition is the set of processes that capture, integrate, trans-form, cleanse, reengineer and load source data into the data warehouse and operational data store.
应用推荐