Accelerate Hub Keys
Determines if the BimlFlex Accelerator adds source key columns to the Hub in addition to the Integration Key. When enabled, the source columns that make up the Integration Key (the FlexToBk columns) are carried into the accelerated Hub as additional key columns alongside the Integration Key itself.
When to Change This Setting
Keep the default N unless you specifically want the individual source key parts available on the Hub, for example to query or join Hubs on the original source key columns without unpacking the concatenated Integration Key.
Enabling this setting constrains how the project can be processed: a project with Accelerate Hub Keys enabled must use Pushdown Processing. BimlFlex validates this and reports error PRJ_26005001 when an SSIS project loads a Data Vault target from a source connection without Pushdown Processing enabled.
Related Settings
| Setting | Interaction |
|---|---|
| Accelerate Link Keys | The equivalent option for Link tables; it carries the same Pushdown Processing requirement |
| Accelerate Link Satellite Keys | Controls whether Integration Keys are added to Link Satellites |
| Accelerate Correct Key Names | Controls how the Accelerator names Integration Key columns |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
N.