In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |

  •     QAD Glossary

  • Adding Required xx_ Prefixed Columns
    After the custom path has been created all the way to the dim or fact (non-history) table, add the extra required xx_ prefixed columns to that table. In the column definition, do not give the new xx_ prefixed custom column a source table; it should be blank. Transform those column values to some dummy value and then build a procedure with an xx_ prefix that updates the new custom xx_ columns after the table is populated during its normal load process. Below is an illustration of what the resulting diagram is for a parallel path effort for the dim_item table.