1 Reply Latest reply on Aug 16, 2012 4:22 PM by cdaniels-Oracle

    ORDDM Derived Layer Question

      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