The Fact Table Loader (FTL) is designed to reduce time, when a user needs to create a new data transformation for creating and inserting a new fact into the fact table of the data warehouse.
Example 32.1. Example of usage
Let's assume, that the user has some input data from a production database saved in a text file. From this data he needs to create a fact which is then inserted into a fact table of the data warehouse. In the process of creating mentioned fact, user has to use some of the dimensional tables of the same data warehouse to find a dimension key for the row where the field from the text file equals the field of the selected column. Using CloverETL this can be done by using the ExtHashJoin and DBLookup components. More, let's assume the user has to process 4 or more dimensional tables. To create a data transformation (graph) which has this functionality the user needs to use 10 or more components and set all the required options. It takes some time. For this there is the FTL tool.
FTL is a wizard integrated into CloverETL Designer. In the wizard the user inputs relevant information and the wizard creates a new CloverETL graph with the requested data transformation.
In the following sections we will show the following:
How Fact Table Loader wizard should be launched. See Launching Fact Table Loader Wizard.
How should be worked with Fact Table Loader wizard. See Working with Fact Table Loader Wizard.
How a created graph looks like. See Created graph.