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

This article is the one-to-many relationship in a relational model. For example, in a geography schema having tables Region, State, and City: many states are in a given region, but no states are...

Share this page:
Follow us:
Task Runner