This discussion is archived
1 Reply Latest reply: Aug 16, 2012 9:22 AM by 370761 RSS

ORDDM Derived Layer Question

user791903 Newbie
Currently Being Moderated
This is a question regarding best practices. The ORDM tutorial from Oracle (http://st-curriculum.oracle.com/tutorial/ORDMTutorial/player.htm) states for the ORDM Derived Layer:
"The Derived Data Model uses a low-level combination of base tables to provide information that can only be derived from base table data".

And the Oracle Documentation (http://docs.oracle.com/cd/B19306_01/bi.102/e14480/intro.htm) states: "The Derived layer stores information derived from the Base and Reference layers"

Am I right in saying that according to the layered architecture of the ORDM data model, we should populate the derived layer purely from the 3NF Base Tables, Lookups & Reference Tables?
Specifically, having a Derived Table in the Derived Layer populating another Derived Table is a violation of standards. Is this a correct assumption?


Thomas Hefter
Oracle Support Services on behalf of a customer

Edited by: user791903 on Aug 16, 2012 1:10 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points