1. Analytical Application Infrastructure User Guide
  2. Data Model Management
  3. OFSAA Data Model Extensions through the SQL Data Modeler
  4. Customization Process
  5. Addition of New Tables

Addition of New Tables

  • Tables are created only when the physical table UDP ‘Custom’ is set to YES.
  • Columns of a custom table are considered as Custom. It is not required to mark them explicitly as Custom with a UDP.
  • One or more custom tables having a relationship with each other can be added together.
  • If any of the custom tables is establishing a relationship with an existing table from OOB, then ensure that the parent tables with keys or the entire parent table structure are available in the SQL Modeler Model. Only the immediate parent is required to be added, not beyond that.
  • Table and Column display names must be represented as notes in SQL Modeler (whereas it used to be a logical name in erwin).
  • As model level UDPs are not supported by SQL Modeler, Model UDP - VERSION is expected to be added at the table level. If it is missing for any table, the default value will be 80000.