Back to CloverDX Blog on Data Integration

Loading Data Warehouse - Fact Table Load Wizard

Posted by Viliam Wallace on August 24, 2010

Note: We are sorry but this feature is no longer supported in current version of CloverDX.

Users who are using CloverDX for data-warehousing often need to create a data transformation which populates DWH fact table with transaction data from source system. Each such transformation contains many components that join keys from dimensional tables to processing records.

There is no problem, in case a user uses only few dimensional tables in process of loading fact table. But if there are much more tables, it is quite uncomfortable to build a whole transformation graph and set all components, create needed metadata and establish a database connection after that. For this we created in CloverDX 3.0 a brand new Fact Table Load Wizard that dramatically simplifies and speeds up development process of a transformation. This wizard can be found in the menu of CloverDX wizards.

Loading Data Warehouse

What does a user needs as an input into the wizard is just a data file with source data which should be loaded into the fact table and a metadata describing structure of this data file. As the input exists, a user can use the wizard and enter requested information. For more information how to use the wizard please see related documentation on the official CloverDX web site.

Loading Data Warehouse

The wizard generates ready-to-run graphs, but a user is welcome to change whatever is needed.

Loading Data Warehouse

Data integration software and ETL tools provided by the CloverDX platform (formerly known as CloverETL) offer solutions for data management tasks such as data integration, data migration, or data quality. CloverDX is a vital part of enterprise solutions such as data warehousing, business intelligence (BI) or master data management (MDM). CloverDX Designer (formerly known as CloverETL Designer) is a visual data transformation designer that helps define data flows and transformations in a quick, visual, and intuitive way. CloverDX Server (formerly known as CloverETL Server) is an enterprise ETL and data integration runtime environment. It offers a set of enterprise features such as automation, monitoring, user management, real-time ETL, data API services, clustering, or cloud data integration.