Fact Table Loader

The Fact Table Loader object in the Data Warehouse section of the toolbox allows you to write data to a fact table. You can connect to a deployed model and then choose a fact table that you want to write your data to.

In this article, we’ll be taking a look at how you can configure and use the Fact Table Loader object in Astera Data Warehouse Builder.

Video

Example

Here, we have a sample dimensional model that has been deployed on the server.

01-sample-dimensional-model

This model contains four dimension entities, one fact entity, and a date dimension entity. In this example, we’ll be loading data into the Sale fact entity using the Fact Table Loader object.

Configuring the Fact Table Loader Object

1. To get the Fact Table Loader object from the toolbox, go to Toolbox > Data Warehouse > Fact Table Loader.

02-toolbox-fact-table-loader

2. Drag and drop the Fact Table Loader object onto the dataflow designer.

adding-fact-table-loader

03-fact-table-loader

This object is currently empty because we are yet to configure it.

3. To open the properties window of the Fact Table Loader object, right-click on it and select Properties form the context menu. Alternatively, you can double-click on the object.

04-fact-table-loader-properties

A configuration window will appear on your screen.

05-configuration0window

Using this window, you can configure the Fact Table Loader object.

4. On the Database Connection screen, you’ll notice that the Data Provider dropdown menu is limited to just one option: Astera Data Model. This option represents the data models that are deployed on the server and are available for usage.

06-astera-data-model

Once you’ve provided your Astera Data Warehouse Builder credentials and a server connection, you can select a deployed model from the Database dropdown menu.

07-database-dropdown

Note: The default username is admin, and the default password is Admin123.

In this case, we’ll select DW_Sale, which represents the dimensional model that we saw earlier.

5. On the Pick Table screen, you can pick a table from the fact entities present in the deployed model that you’ve chosen.

08-database-connection

The Pick Table dropdown menu allows you to choose from the fact entities in the model.

09-pick-table

In this case, there’s only one fact table, titled Sale, in the deployed dimensional model. Therefore, we’ll pick that table from the menu.

10-pick-table

Once you’ve chosen a fact table, click Next.

6. On the Layout Builder screen, you can view the layout of the entity, including the characteristics and roles of each field. However, you cannot modify the layout of the entity from this screen.

11-fact-layout-builder

Click OK to close the configuration window.

The Fact Table Loader object has now been configured and you’ll be able to see all of the fields in the object layout.

12-fact-table-loader-object

You can now map the incoming source data to each relevant field.

7. Choose a relevant source object from the toolbox and configure it so as to extract the source data. In this case, we’ll use a Data Model Query object to extract data from multiple tables in the source deployment, and then map the relevant fields to the Fact Table Loader object.

13-fact-table-loader-dataflow

To learn more about the Data Model Query object, click here.

You can now run the dataflow to load data into the fact table.

This concludes our discussion on the Fact Table Loader object.