Release passed SIT:
STEP 1: Execute generator to create merge procs for each target table >>> 14 target tables; less than 5 minutes to create merge scripts.
Validation: Query target table for each and compare against MERGE statement.
STEP 2: Save GDE payload (JSON) to Object Storage bucket >>> three distinct MOs with 10 records each.
Validation: Inspect Object Storage bucket and logs.
STEP 3: Live Feed into Autonomous DB (ATP) >>> inserted each JSON document into Ingest table as BLOB collection.
Validation: Inspect logs and query table, compare against GDE payload.
STEP 4: Parse BLOB into Staging Table >>> strip metadata and convert to CLOB. Each record in stage now fully parsable.
Validation: Query ATP table and compare against GDE payload.
STEP 5: Execute generated merge scripts >>> insert JSON_DATA record from stage into individual target tables.
Validation: Query ATP target table(s) and compare against GDE payload.
Validation: Query source application table(s) and compare against ATP tables(s).
