All fully functioning ETL programs and scripts should reside in the production ETL program library.
Production application program library
All fully functioning access and analysis programs and scripts should reside in the production application program library.
Production meta data repository program library
All fully functioning meta data repository programs and scripts should reside in the meta data repository program library.
Production BI target databases
The data definition language (DDL) and data control language (DCL) SQL statements are run in the production environment to build the production BI target databases. The ETL initial load process and the ETL historical load process are run to populate these production BI target databases.
Production meta data repository database
The DDL and DCL statements for the meta data repository are run in the production environment to build the production meta data repository database. The meta data migration programs and tool interface programs are run to populate the production meta data repository database with business meta data, technical meta data, and ETL meta data (load statistics, reconciliation totals, data quality metrics) from the initial load and historical load processes.
Production documentation
Production documentation for the BI application includes:
- Operating procedures for operations staff covering the ETL process and all scheduled application report jobs
- Reference guide for the help desk staff and the business people with instructions on how to use the BI application