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:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Stuart Ramage

I am a Consulting Technical Manager for Oracle Corporation, and a member of the OU Black Belt Team, based in Hobart Tasmania.
I have worked in the Utility arena since 1999 on the Oracle UGBU product line, in a variety of roles including Conversion, Technical and Functional Architect.

Contact me on:

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today