Skip to main content

Infer Dimension Members

Determines if the Data Mart process infers Dimension Members.

When enabled, the generated SSIS Dimension and Fact loads include an inferred-member script component that creates placeholder ("dummy") records for referenced dimension members that do not yet exist, so reference keys resolve during the load instead of failing or defaulting. This applies to SSIS (non-pushdown) processing where the target connection supports ADO.NET.

When to Change This Setting​

Keep the default N when dimensions are always loaded before the facts that reference them. Enable it when early-arriving facts are expected (fact rows that reference dimension members which have not been loaded yet) so the load creates the placeholder member and continues.

Notes​

  • This setting is part of the Data Mart settings category.
  • The default value for this setting is N.