# 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 Stack.

### Video

{% embed url="<https://youtu.be/f-_0XTFpvQ8>" %}

### Example

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

![](/files/565m4hxrOhFn2I3qbG9q)

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*.

![](/files/3cEiYA8rHsyWixet6cWR)

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

![](/files/xtoXWcCXcUHxhzjRpYoK)

![](/files/RCRy9Kev9ubwK8WtTwaA)

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.

![](/files/EnznBuiKGi1H6bJ6MugL)

A configuration window will appear on your screen.

![](/files/ZnUbJzEU0PVIO1vR2YlL)

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.

![](https://docs.astera.com/projects/dwbuilder/en/latest/_images/06-astera-data-model.PNG)

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

![](/files/3Rns8qnq5lgulr7YVKmt)

{% hint style="info" %}
**Note**: The default username is *admin,* and the default password is *Admin123*.
{% endhint %}

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.

![](/files/9NDYCJ3XuuKBozxil56B)

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

![](/files/WYhxTeLwQ5aIt5LKvNoJ)

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.

![](/files/zYqWx56s7VZCXreWSEtB)

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.

![](/files/Uuv5MFtSeZ88GqefRoYj)

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.

![](/files/kipYgry007YWIiP5KMTI)

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.

![](/files/Qk1QXEeJtjSYfDQ6M24T)

To learn more about the *Data Model Query* object, [click here](/astera-data-stack-v10/dataflows/sources/data-model-query.md).

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

This concludes our discussion on the *Fact Table Loader* object.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v10/dataflows/data-warehouse/fact-table-loader.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.