Conversion Batch Controls

Batch Control

Description

K1-CNVLD

Conversion - Load Data using SQL Loader.

This process facilitates the legacy data extract upload using SQL Loader. The input data files are expected to be uploaded to a file storage location. See Input and Output File Location for more information about file storage locations.

One run uploads the data into a single target Table or Maintenance Object.

The process is multi-threaded.

This process is discussed in more details in the Configuring Data Load Batch Controls for Conversion Project chapter

K1-CNVDS

Conversion - Disable Conversion

This process resets the environment indicators and prevents further conversion activities. Once conversion is disabled, the following actions are blocked:

• Switching between Conversion and Production

• Table truncation

• Disable Indexes and Rebuilding the Statistics

• Data insertion into Production

• Data upload into staging

K1-CNVEN

Conversion - Enable Conversion

This process resets the environment indicators and enables it for conversion activities. It should be executed at the start of the Conversion project.

K1-DRPIN

Conversion - Disable Indexes on Production Tables

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the process disables indexes on all converted tables in Production schema

K1-SDSIN

Conversion - Disable Indexes on Staging Tables

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the process disables indexes on all converted tables in Staging schema

K1-RIUSP

Conversion - Rebuild Indexes and Update Statistics in Production

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the process rebuilds indexes and updates statistics on all converted tables in Production schema

• Specify the sampling size (percentage) for statistics gathering. If not specified, the system will use default dbms_​stats.auto_​sample_​size.

• Specify whether you wish to rebuild indexes, to gather table statistics or both.

It is recommended to rebuild the indexes and update statistics right after the data upload.

K1-RIUSS

Conversion - Rebuild Indexes and Update Statistics in Staging

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the process rebuilds indexes and updates statistics on all converted tables in Staging schema

• Specify the sampling size (percentage) for statistics gathering. If not specified, the system will use default dbms_​stats.auto_​sample_​size

• Specify whether you wish to rebuild indexes, to gather table statistics or both

It is recommended to rebuild the indexes and update statistics right after the data upload.

K1-CLNTB

Conversion - Truncate Tables in Production

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the truncates all converted tables in Production schema

K1-SCLTB

Conversion - Truncate Tables in Staging

This process can be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the truncates all converted tables in Staging schema

K1-CLNKY

Conversion - Truncate Key Reference Tables

This process is allowed to run only in the Staging schema and may be used in two modes:

• Populate Table or Maintenance Object batch parameter to process specific object

• If no specific target is populated, the truncates all Key Reference tables in Staging schema