@@rs on FlexToBk
Enable this setting to verify that all keys using the FlexToBk expression include the @@rs parameter for source objects. This ensures that keys are unique, thereby maintaining data integrity.
When enabled, build validation reports error FlexToBkIncludeRs for every Integration Key or reference column on a source object whose FlexToBk expression does not include @@rs, 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 when your keying standard does not require the record source in every key. Enable it when keys must carry the record source for uniqueness across source systems, so any FlexToBk expression missing @@rs is caught at build time.
Related Settings
| Setting | Interaction |
|---|---|
| Add Record Source To Integration Key | Makes Import Metadata include @@rs in generated FlexToBk expressions |
| FlexToBk on IntegrationKey | Validates that Integration Keys define a FlexToBk expression at all |
| FlexToBk on Reference | The equivalent presence validation for reference keys |
Notes
- This setting is part of the Model settings category.
- The default value for this setting is
N.