Data Modeling - Orphan
1 - About
An orphan instance is an instance that does not have a corresponding existing parent record.
An orphan is created if you insert an instance that does not have an existing parent instance.
For example, you load an article into a fact table but this article code is not present in the article dimension. This record (instance) is an orphan record.
2 - Articles Related
3 - Management
When loading orphan instance, you can:
- Reject the instance
- Insert the instance in an other table
- Or set an other instance value to regroup the orphan instances (the -1 of -2 value)