Data Vault Reference Data in BimlFlex

Reference Tables Reference tables are a logical collection of code and description lookup structures. They utilize natural business keys and are constructed from standard Hub, Link, and Satellite entities.

Resolution occurs through queries at run time.

They do not house nor require foreign keys.

In general, the codes (natural keys) are found housed in the Satellites as they typically describe other keys or other relationships.