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.

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)
  • Bookmark "Data Modeling - Orphan" at del.icio.us
  • Bookmark "Data Modeling - Orphan" at Digg
  • Bookmark "Data Modeling - Orphan" at Ask
  • Bookmark "Data Modeling - Orphan" at Google
  • Bookmark "Data Modeling - Orphan" at StumbleUpon
  • Bookmark "Data Modeling - Orphan" at Technorati
  • Bookmark "Data Modeling - Orphan" at Live Bookmarks
  • Bookmark "Data Modeling - Orphan" at Yahoo! Myweb
  • Bookmark "Data Modeling - Orphan" at Facebook
  • Bookmark "Data Modeling - Orphan" at Yahoo! Bookmarks
  • Bookmark "Data Modeling - Orphan" at Twitter
  • Bookmark "Data Modeling - Orphan" at myAOL
data_modeling/orphan.txt ยท Last modified: 2013/01/23 10:44 by gerardnico