Class AggGen


  • public class AggGen
    extends Object
    This class is used to create "lost" and "collapsed" aggregate table creation sql (creates the rdbms table and inserts into it from the base fact table).
    Author:
    Richard M. Emberson
    • Method Detail

      • isReady

        public boolean isReady()
        Return true if this instance is ready to generate the sql. If false, then something went wrong as it was trying to understand the columns.
      • getFactTableName

        protected String getFactTableName()
      • getSqlQuery

        protected SqlQuery getSqlQuery()
      • getFactCount

        protected String getFactCount()
      • addForeignKeyToNotLostColumnUsages

        protected void addForeignKeyToNotLostColumnUsages​(JdbcSchema.Table.Column column)
      • createLost

        public String createLost()
        Return a String containing the sql code to create a lost dimension table.
        Returns:
        lost dimension sql code
      • insertIntoLost

        public String insertIntoLost()
        Return the sql code to populate a lost dimension table from the fact table.
      • createCollapsed

        public String createCollapsed()
        Return a String containing the sql code to create a collapsed dimension table.
        Returns:
        collapsed dimension sql code
      • insertIntoCollapsed

        public String insertIntoCollapsed()
        Return the sql code to populate a collapsed dimension table from the fact table.