Skip to main content
Submitted

Change types of SCD Is Current and SCD Is Tombstone to smaller types

  • February 27, 2020
  • 1 reply
  • 1 view
R
Forum|alt.badge.img

Currently the fields added by history functionality to indicate status are of type bigint. While this may have less of an impact for relatively small dimensions, it will add up for larger tables. Using a bit would mean one byte per record and fit with the boolean nature of the field, using a bigint for both takes 16 bytes per record.

    1 reply

    A
    • Alex Wijnen
    • Participating Frequently
    • February 12, 2021

    Thanks for your product feedback.

    We have passed your input to our R&D department for further evaluation.

    The roadmap of our product is focused on a split in ODX, MSW, Semantic Layer and Customer Portal.

    With that split we will see new features and functions appear that might exceed your expectations or make the request obsolete.

    Terms & ConditionsCookie settingsAccessibility statement