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.
Here, we have a sample dimensional model that has been deployed on the server.
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.
To get the Fact Table Loader object from the toolbox, go to Toolbox > Data Warehouse > Fact Table Loader.
Drag and drop the Fact Table Loader object onto the dataflow designer.
This object is currently empty because we are yet to configure it.
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.
A configuration window will appear on your screen.
Using this window, you can configure the Fact Table Loader object.
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.
Once you’ve provided your Astera Data Stack credentials and a server connection, you can select a deployed model from the Database dropdown menu.
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.
On the Pick Table screen, you can pick a table from the fact entities present in the deployed model that you’ve chosen.
The Pick Table dropdown menu allows you to choose from the fact entities in the model.
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.
Once you’ve chosen a fact table, click Next.
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.
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.
You can now map the incoming source data to each relevant field.
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.
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.
The Dimension Loader object in the Data Warehouse section of the toolbox allows you to write data to a dimension table. You can connect to a deployed dimension model and then choose a dimension 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 Dimension Loader object in Astera Data Stack.
Here, we have a sample dimensional model that has been deployed to the server.
This model contains four dimension entities, one fact entity, and a date dimension entity. In this example, we’ll be loading data into the Customer dimension using the Dimension Loader object.
To get the Dimension Loader object from the toolbox, go to Toolbox > Data Warehouse > Dimension Loader.
Drag and drop the Dimension Loader object onto the dataflow designer.
The object is currently empty because we are yet to configure it.
To open the properties window of the Dimension Loader object, right-click on it and select Properties from the context menu. Alternatively, you can double-click on the object.
A configuration window will appear on your screen.
Using this window, you can configure the Dimension Loader object.
On the Database Connection screen, you can choose a data provider from the options available in the Data Provider dropdown menu.
Since the dimension entities are present in the deployed dimensional model, we’ll select Astera Data Model from the list of data providers.
Once you’ve provided your Astera Data Stack credentials, you can select a deployed model from the Database dropdown menu.
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.
Once you’ve chosen a deployed model, click Next.
On the Pick Table screen, you can pick a table from the dimension entities present in the deployed model that you’ve chosen.
The Pick Table dropdown menu allows you to choose from the dimension entities.
In this case, we’ll choose the Customer table from the list.
Once you’ve chosen a dimension table, click Next.
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.
Click OK to close the configuration window.
The Dimension Loader object has now been configured and you’ll be able to see all of the fields in the object layout.
You can now map the incoming source data to each relevant field.
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 Database Table Source object to extract data from the source deployment, and then map the relevant fields to the Dimension Loader object.
To learn more about the Database Table Source object, click here.
You can now run the dataflow to load data into the dimension table.
This concludes our discussion on the Dimension Loader object in Astera Data Stack.
The Data Vault Loader object in the Data Warehouse section of the Toolbox allows you to write data to a Data Vault Entity such as a Hub, Link, or Satellite table. You can connect to a deployed model and then choose the entity type and table that you want to write your data to.
In this article, we will look at how to configure and use the Data Vault Loader object.
For our use case, we will be using the Data Vault Loader object to write data to an Orders Hub, a Customers-Orders Link, and an Orders Satellite.
To get the Data Vault Loader object from the Toolbox, go to Toolbox > Data Warehouse > Data Vault loader.
Drag-and-drop the Data Vault loader object onto the dataflow designer.
This object is currently empty as it has not been configured yet.
To configure this object, right-click on the object header and select Properties from the context menu. Alternatively, you can also double-click the object header. A configuration window will appear on your screen.
Here, you can configure the Data Vault loader object.
On the Database Connection screen, you will 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.
Once you have provided your credentials and a server connection, you can select a deployed, Data Vault model from the Database dropdown menu, which consists of the entities that need to be populated.
Note: The default username is admin, and the default password is Admin123.
For our use case, we have selected the DataVault_Customers_Orders database which consists of the Orders and Customers Data Vault entities.
Now, click Next. On the Pick Table screen, you select an entity type: a Hub, Link, or Satellite. First, select the Hub entity type.
Based on the selected entity, the Pick Table dropdown menu dynamically filters out all related tables and their parent entities if any.
Hub entities do not have any related/attached parent entities.
Link entities can have related/attached Hub and Bridge tables.
Satellite entities can have related/attached Hub, Link, and Point-In-Time (PIT) tables.
Note: Once a Link or Satellite entity has been selected for loading, the Data Vault Loader object will check whether there is data present in the attached/related tables, so that when data is loaded into a Link or Satellite, there are no errors regarding to referential integrity.
As we have selected the entity type Hub, and since Hub entities do not have related parent entities, we will simply select the OrdersHub table from the drop-down. Once done, click Next.
On the Layout Builder screen, you can view the layout of the selected entity, including the characteristics and roles of each field. However, you cannot modify the layout of the entity from this screen.
Now, Click OK to close the configuration window. The Data Vault Loader object has now been configured and you will be able to see all fields in the object layout.
You can now map the incoming source data to each relevant, mappable field. This can be done using a relevant source object from the Toolbox and configuring it so as to extract the source data.
Note: Based on the selected entity (Hub, Link, or Satellite), different fields will appear in the configured Data Vault Loader object, and only some of these will be mappable fields. The Load Data Source (LoadSc) and Load Date Time (LoadedDate) fields are present in all configured Data Vault Loader objects, regardless of the chosen entity.
While the Load Date Time field is derived automatically, users will need to provide the relevant source value to the LoadSc field. This can be done using variables.
Hub entity:
Requires users to map business keys
Does not consist of any attributes
Link entity:
Requires users to map business keys of the related Hubs
Satellite entity:
Consists of attributes, all of which are mappable.
Consists of a RecordHash which is calculated automatically.
This concludes using the Data Vault Loader object in Astera Data Stack.
