Table classification

  • 12 August 2020
  • 3 replies

How does "Table classification" in Table Settings affect a table ?
Can't find any information in the user guide or google.

For which cases "Dimension- /Fact Table (normal + large) are use full ?

Many thanks for your help.

Cheers Alex


Best answer by JTreadwell 15 August 2020, 08:38

View original

3 replies

Userlevel 3
Badge +5

Hi Alex, this option is only used with the managed execution option of the same name.
Excerpt from the user guide:” Classification: When more than one object is ready to executed, TimeXtender prioritizes the objects based on their table classification. The order will be “Fact Table – Large”, “Fact Table”, “Dimension Table – Large”, “Dimension Table”. If two tables have the same classification TimeXtender will use the execution number as the secondary criteria.”
However we still suggest execution time as the most efficient option in most cases.

Yes, thats what I was looking for. Thank you very much, Joseph.

Userlevel 3
Badge +5