Skip to main content

Pad Integration Key

Number of characters to pad the Integration Key to.

Import Metadata sizes the derived Integration Key column (and derived reference key columns) by rounding the combined length of the concatenated source key columns up to the next multiple of this value — with the default 100, keys become 100, 200, 300 characters wide and so on. A value of 1 or less disables the padding, sizing the column to the concatenated length plus one.

This setting provides the default for the Import Metadata dialog and can be overridden per connection or project.

When to Change This Setting​

Keep the default 100 for uniform key column sizes that absorb source key growth without re-import. Lower it when storage width matters and source keys are short and stable; raise it when concatenated keys are long and you want headroom in a single size step.

SettingInteraction
Infer Integration Key FromDetermines which columns make up the Integration Key being sized
Integration Key Concatenation OrderThe order of the concatenated columns
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 100.