Description
The Property named Implementation Type is available when you edit a Model Object.
It defines how a Model Object is persisted.
Format
The Implementation Type is a List of predefined values.
The available options are:
- Virtual:
- Only a View will be generated
- Data is not stored persistently
- Cached:
- A View and a Table will be generated
- The table is loaded using a truncate-then-insert strategy
- The data is persisted for a single load.
- Permanent:
- A View and a Table will be generated
- The table is loaded using a merge (insert/update statements) strategy.
- The data is persisted permanently
Example:
Default and available options
The default and available values vary depending on the Model Object Type:
| Model Object Type | Default Value | Available options |
| Stage | Cached | Cached, Virtual, Permanent |
| Core Composite | Virtual | Cached, Virtual |
| Entity | Permanent | Permanent |
| Fact | Permanent | Permanent |
| Raw Vault Composite | Cached | Cached, Virtual |
| Hub | Permanent | Permanent |
| Satellite | Permanent | Permanent |
| Link | Permanent | Permanent |
| Link Satellite | Permanent | Permanent |
| Multi-Active Satellite | Permanent | Permanent |
| Same as Link | Permanent | Permanent |
| Hierarchical Link | Permanent | Permanent |
| Effectivity Satellite | Permanent | Permanent |
| Record Tracking Satellite | Permanent | Permanent |
| Effectivity Link Satellite | Permanent | Permanent |
| Record Tracking Link Satellite | Permanent | Permanent |
| Non-Historized Link Satellite | Permanent | Permanent |
| PIT | Permanent | Permanent |
| Reference Table | Permanent | Permanent |
| Driving Key Link | Permanent | Permanent |
| Business Vault Composite | Virtual | Cached, Virtual |
| Business Hub | Permanent | Permanent |
| Business Satellite | Permanent | Permanent |
| Business Link | Permanent | Permanent |
| Business Link Satellite | Permanent | Permanent |
| Same as Business Link | Permanent | Permanent |
| Hierarchical Business Link | Permanent | Permanent |
| Effectivity Business Satellite | Permanent | Permanent |
| Record Tracking Business Link Satellite | Permanent | Permanent |
| Effectivity Business Link Satellite | Permanent | Permanent |
| Non-Historized Business Link Satellite | Permanent | Permanent |
| Business PIT | Permanent | Permanent |
| Mart Composite | Virtual | Cached, Virtual |
| Mart Dimension | Permanent | Permanent |
| Mart Fact | Permanent | Permanent |
Impact
The value of Implementation Type is used during the generation process to determine which target objects should be created for a Model Object.
If you forgot to set the correct persistence for a Model Object and it has already been deployed, make sure to delete the target database objects before redeploying.