FlexToBk on IntegrationKey
Enable this setting to verify that all source objects define the FlexToBk expression for their integration keys. This validation ensures consistency across your solution, maintaining data integrity and alignment throughout the system.
When enabled, build validation reports error IKeyRequiresFlexToBk for every Integration Key column on a source object that has no FlexToBk expression, and the build is treated as having metadata errors. The check applies to source-stage objects only, and the setting can be overridden per object.
When to Change This Setting
Keep the default N while a model is being built up, since partially keyed objects would fail the build. Enable it once the model is expected to be complete, so any source Integration Key missing its FlexToBk expression is caught at build time instead of producing wrong key values at load time.
Related Settings
| Setting | Interaction |
|---|---|
| FlexToBk on Reference | The equivalent validation for reference key columns |
| @@rs on FlexToBk | Validates that FlexToBk expressions include @@rs |
Notes
- This setting is part of the Model settings category.
- The default value for this setting is
N.