Logical Data Modeling - Orphan (Entity, Instance)

Data System Architecture


An orphan instance is an instance (entity) that does not have a corresponding existing parent record in a parent-child relationship.

An orphan is created if you insert an instance that does not have an existing parent instance.


When 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.


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)

Discover More
One To Many Hello Data Model
JPA - How to define a @One-to-Many relationship ?

To define a one-to-many relationship, the following annotation is used @OneToMany. The Interface with parameters and default values: where: targetEntity is the entity class that is the target...
Key Lookup Inputconnection
OWB - Key lookup operator

Use the Key Lookup operator to lookup (retrieve) data from a set of data (filter,table, view, cube, or dimension ...) For example, use the Key Lookup operator when you define a mapping that loads...
Data System Architecture
Relational Data Modeling - One-to-many / May-to-one Relationship

one-to-many cardinality in a relational modeling environment. A One-to-many is also known as Primary Key-Foreign Key Relationships In relational databases, these many-to-one relationships are often enforced...

Share this page:
Follow us:
Task Runner