Notifications
Clear all

What table stereotype do you use to persist integer dimension keys for information marts? Poll is created on Jul 21, 2021

  
  
  
  
  
  
  
  
  
  
  
Poll results: What table stereotype do you use to persist integer dimension keys for information marts?
Voter(s): 3
Poll is created on Jul 21, 2021
Standard satellite  -  votes: 0 / 0%
0
0%
Computed satellite  -  votes: 2 / 66.7%
2
66.7%
Bridge  -  votes: 0 / 0%
0
0%
Point-in-time  -  votes: 3 / 100%
3
100%
Exploration link  -  votes: 0 / 0%
0
0%
Same as link  -  votes: 0 / 0%
0
0%
Hierarchical link  -  votes: 0 / 0%
0
0%
Non-historized link  -  votes: 0 / 0%
0
0%
Non-historized satellite  -  votes: 0 / 0%
0
0%
Other data vault stereotype (post reply with details)  -  votes: 0 / 0%
0
0%
Other non-data vault stereotype (post reply with details)  -  votes: 0 / 0%
0
0%

What table stereotype do you use to persist integer dimension keys for information marts?


Posts: 15
Topic starter
(@jamesdaily)
Active Member
Joined: 2 years ago

When building star schemas for consumption with certain client tools, integer keys may either be required or perform better than exposing hash keys from the raw vault.  What stereotype do you consider best suited to persisting these numeric sequences for use with virtual facts and dimensions?  

The associated poll is multiple choice if you prefer different stereotypes different dimension stereotypes (e.g. "Type 1" or "Type 2").  

Reply
4 Replies