Staging to Prod schema validation

Question Received: What is required to migrate data from the final staging tables into the production schema? The documentation refers to validation, creating keys, various types of balances. What quality does the data have to be? There are outstanding issues which raise questions about some data items and configuration is still not complete for every data item.

Answer: In order to migrate the data from staging to Production, it is expected that the following will hold true:
1. all validation performed via the frontend validation routines will be met by the converted data (all table fields will meet the business needs and code-based tables contain values defined in the Config tables.
2. all Primary keys on the staging tables are unique
3. all foreign keys on the staging tables relate to parent records (no orphan foreign keys exist).
4. all inter-table relationships have been satisfied for particular business object (eg. a Person has at least one record on Person ID, and a Bill, Adjustment or Payment has a matching record on CI_FT)
5. any custom algorithm validation is met.

Comments

Popular posts from this blog

Threading...

Tidy Balances.. I don't really hate it

Increasing batch run throughput