The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account
  • Select:
  • Description
  • Default Value

Choose a tab to view either setting descriptions or examples.

Group Section Type Setting Description
Data Vault Accelerator Boolean Datatype Accelerate Link Satellite Should the accelerator create Link Satellites for effectiveness and attributes from source metadata
Data Vault Accelerator Boolean Datatype Accelerate Link Satellite Keys Should the accelerator add the Integration Key to the Link Satellites for effectiveness
Data Vault Accelerator Boolean Datatype Append Link Satellite Record Source Should the Accelerator append the RecordSource to the Link Satellite name
Data Vault Accelerator Boolean Datatype Accelerate Link Keys Should the Accelerator add source key columns to the Link in addition to the Integration Key
Data Vault Accelerator Boolean Datatype Stage Reduce Link Keys Enable this to reduce additional Link hash keys in the staging table
Data Vault Accelerator Boolean Datatype Accelerate Two Way Links Should the Accelerator split all Links into Two Way Links or combine all Non Nullable references into a single Link or Unit of Work
Data Vault Process Boolean Datatype Infer Link Hub Should the Data Vault load from a staging table also load all secondary hubs that are part of any Link loads. For scenarios where the referenced table loads all keys as part of the same process it is normally possible to defer that load to the separate table.

Sample Scenario:

A source to staging to Data Vault load is done on the "Product" and "ProductCategory" tables from AdventureWorksLT.

The Product table populates the HUB_Product table. The ProductCategory table populates the HUB_ProductCategory table.

The Product table contains a FK constraint to the Product Category and the ProductCategoryId column in the Product table refers to the category a product is in.

The normal Link load would use the Product BK and the Product Category BK defined in the Product source table metadata to load the Link. It would not load any data in to the HUB_ProductCategory as that is being loaded from the ProductCategory source table.

As this is a database source it is probably safe to assume the referential integrity in the source means all ProductCategory BK data in the Product table is also in the ProductCategory table. As such it is unnecessary to load that data twice.

For other sources it might be necessary to load the HUB table from both sources, either due to late arriving data, missing data or as a prudent safety measure to ensure it is possible to inner join Link and Hubs without losing rows.

Setting the "DvInferLinkHub" to true will allow the Product to populate the ProductCategory Hub as part of that source table load
Data Vault Naming Naming Text Datatype Append Link The string to append to Link names
Data Vault Naming Naming Text Datatype Append Link Satellite The string to append to Link Satellite names
Data Vault Naming Naming Text Datatype Append Hierarchy Link The string to append to Hierarchical Link names
Data Vault Naming Naming Text Datatype Append Same As Link The string to append to Same As Link names
Model Settings Text Datatype Key Ends With The strings that BimlFlex interprets as key identifiers.
For a source table with a column "ProductCategoryId" that links to a ProductCategory table, BimlFlex will create a Model Reference called "ProductCategory" as name
Group Section Type Setting Default Value
Data Vault Accelerator Boolean Datatype Accelerate Link Satellite false
Data Vault Accelerator Boolean Datatype Accelerate Link Satellite Keys true
Data Vault Accelerator Boolean Datatype Append Link Satellite Record Source true
Data Vault Accelerator Boolean Datatype Accelerate Link Keys false
Data Vault Accelerator Boolean Datatype Stage Reduce Link Keys false
Data Vault Accelerator Boolean Datatype Accelerate Two Way Links false
Data Vault Process Boolean Datatype Infer Link Hub false
Data Vault Naming Naming Text Datatype Append Link LNK
Data Vault Naming Naming Text Datatype Append Link Satellite LSAT
Data Vault Naming Naming Text Datatype Append Hierarchy Link HAL
Data Vault Naming Naming Text Datatype Append Same As Link SAL
Model Settings Text Datatype Key Ends With Id,Code,No,Key

© Varigence