Skip to main content

Integration Key Concatenation Order

Determines the order of columns in the derived Integration Key. This can be derived either from the column Ordinal in the table definition or from the column order in the Primary Key constraint.

Options: ObjectColumns, KeyColumns

OptionBehavior
ObjectColumns (default)The FlexToBk expression concatenates the key columns in the order they appear in the source table definition
KeyColumnsThe FlexToBk expression concatenates the key columns in the order they appear in the key constraint

Import Metadata builds the derived Integration Key column's FlexToBk expression in this order. Because the Integration Key value is the concatenation of these columns, changing the order changes the key values that subsequent loads produce for multi-column keys.

When to Change This Setting​

Keep the default ObjectColumns for a stable, table-definition-driven order. Use KeyColumns when the Primary Key constraint's column order is the intended business key order and it differs from the column order in the table. Decide before loading data — switching afterwards changes generated key values for multi-column keys.

SettingInteraction
Infer Integration Key FromDetermines which columns are treated as the Integration Key during import
Add Record Source To Integration KeyAdds @@rs as the first part of the concatenated key
Append Integration KeyThe affix used to name the derived Integration Key column

Notes​

  • This setting is part of the Model settings category.
  • The default value for this setting is ObjectColumns.