Entity types | Agile Data Engine

Agile Data Engine has different Entity types, both logical and physical. When a new entity is created, the user must choose a type (logical type) and physical type. Much of the automation logic in ADE is based on these entity types. For example, the logical type assigns a naming convention and what default attributes an entity should have. The physical type defines how the entity is created/deployed as a physical code object into runtime environments.

See also:

List of logical entity types

Type	header	Description
LOGICAL	Logical entity	Used for logical data modelling.
SOURCE	Source entity	Defines source data.
STAGE	Stage entity	Entity for staging source data.
HUB	Hub	Data Vault Hub entities define business keys.
SAT	Satellite	Data Vault Satellite entities store history of descriptive attributes of business keys.
SAT_C	Satellite current view	Satellite current views return current satellite records. This entity type is automatically created for SAT entities.
SAT_MA	Multi-Active Satellite	Data Vault multi-active satellite versions data over set of rows per Data Vault key.
S_SAT	Status satellite	Data Vault status satellites track the status of a Hub or a Link.
S_SAT_C	Status satellite current view	Status satellite current views return current status satellite records. This entity type is automatically created for S_SAT entities.
LINK	Link	Data Vault Links define relationships between business keys.
PIT	Point-in-time entity	Data Vault Point-in-time entity.
BRIDGE	Bridge entity	Data Vault Bridge entity.
REF	Reference entity	Data Vault or Publish Reference entity.
DIM	Dimension	Publish Dimension entity (Dimensional modeling).
FACT	Fact	Publish Fact entity (Dimensional modeling).
FLAT	Flat entity	Publish Flat entity. Combining data from Dimensions and Facts into one table.
GENERIC	Generic entity	Any Generic Entity which is not tied into any specific modelling technique.