Clear all

Row Identifiers for Stellite Tables

Posts: 5
Topic starter
Active Member
Joined: 1 year ago

Dear Community,

Is it a good practice to declare a row identifier column for the satellites. Since the primary keys are composite, does it make sense to you to create a single column, which uniquely identifies a row in the satellite? A good practical purpose for this would be to build a tabular model on top of the vault raw layer - since tabular model does not support composite business keys as of now, it would be easier to use the row identifier columns in PIT tables.

If you have experience with this, what type would you chose for the row identifier columns?



5 Replies