APP Sources

1 Controller procedures.
2 Source objects.
3 Source schema

Controller procedures.

control_merge("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

control_merge("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Executes merge based on the size of the delta in streams.

Parameters:

P_DB → Database
P_SOURCE → Schema

controller("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

controller("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Executes controller task for a particular schema.

Parameters:

P_DB → Database
P_SOURCE → Schema

deploy_control_merge("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

deploy_control_merge("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Deploys “control_merge“ task for the particular schema

Parameters:

P_DB → Database
P_SOURCE → Schema

deploy_controller("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

deploy_controller("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Deploys “controller“ task for the particular schema

Parameters:

P_DB → Database
P_SOURCE → Schema

suspend_controller("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

suspend_controller("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Suspends controller for the particular schema

Parameters:

P_DB → Database
P_SOURCE → Schema

resume_controller("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

resume_controller("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Resumes controller for the particular schema

Parameters:

P_DB → Database
P_SOURCE → Schema

Source objects.

drop_schema("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216), "P_TYPE" VARCHAR(16777216), "P_NAME" VARCHAR(16777216))

drop_schema("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216),
"P_TYPE" VARCHAR(16777216),
"P_NAME" VARCHAR(16777216))

Drop sub-schema.

Parameters:

P_DB → Database
P_SOURCE → Schema
P_NAME → Name of the schema

create_schema("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216), "P_TYPE" VARCHAR(16777216), "P_NAME" VARCHAR(16777216))

create_schema("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216),
"P_TYPE" VARCHAR(16777216),
"P_NAME" VARCHAR(16777216))

Create sub-schema for source schema.

Parameters:

P_DB → Database
P_SOURCE → Schema
P_TYPE → Type of the schema
Types: - VIEW - TASK - MERGE_TAB - STREAM
P_NAME → Name of the schema

add_source_object("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216), "P_TYPE" VARCHAR(16777216), "P_NAME" VARCHAR(16777216), "P_STATUS" VARCHAR(16777216))

add_source_object("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216),
"P_TYPE" VARCHAR(16777216),
"P_NAME" VARCHAR(16777216),
"P_STATUS" VARCHAR(16777216))

Add source object metadata to the SOURCE_OBJECTS table

Parameters:

P_DB → Database
P_SOURCE → Schema
P_TYPE → Type of the object
Type of source objects: - CONTROLLER - CONTROL_MERGE - SCHEMA
P_STATUS
- A for existing objects
- D for deleted objects

delete_source_object("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

delete_source_object("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Flag objects for specified source as deleted.

Parameters:

P_DB → Database
P_SOURCE → Schema

drop_source_object("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216) "P_TYPE" VARCHAR(16777216), "P_OBJECT" VARCHAR(16777216))

drop_source_object("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216)
"P_TYPE" VARCHAR(16777216),
"P_OBJECT" VARCHAR(16777216))

Delete source object

Parameters:

P_DB → Database
P_SOURCE → Schema
P_TYPE → Type of the object
Type of source objects: - CONTROLLER - CONTROL_MERGE - SCHEMA
P_OBJECT → Name of the object to be drop

get_source_objects_per_type("P_TYPE" VARCHAR(16777216)) get_source_objects_per_type("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216) "P_TYPE" VARCHAR(16777216))

get_source_objects_per_type("P_TYPE" VARCHAR(16777216))

get_source_objects_per_type("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216)
"P_TYPE" VARCHAR(16777216))

Get source object entries from SOURCE_OBJECTS table based on type within the whole application or in a particular schema.

Parameters:

P_DB → Database
P_SOURCE → Schema
P_TYPE → Type of the object
Type of source objects: - CONTROLLER - CONTROL_MERGE - SCHEMA

get_source_objects() get_source_objects("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

get_source_objects()

get_source_objects("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Get source object entries from SOURCE_OBJECTS table within the whole application or in a particular schema.

Parameters:

P_DB → Database
P_SOURCE → Schema

Source schema

register_source("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

register_source("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Create source schema

Parameters:

P_DB → Database
P_SOURCE → Name of the source schema

remove_source("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

remove_source("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Delete source schema and all objects within it

Parameters:

P_DB → Database
P_SOURCE → Name of the source schema

get_source_entry() get_source_entry("P_DB" VARCHAR(16777216))

get_source_entry()

get_source_entry("P_DB" VARCHAR(16777216))

Get list of source schemas

Parameters:

P_DB → Database

deploy_source_tasks()

deploy_source_tasks()
Deploy source tasks. It is automatically executed when creating a new source schema

add_source_entry("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

add_source_entry("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Add metadata entry for source schema

Parameters:

P_DB → Database
P_SOURCE → Name of the source schema

delete_source_entry("P_DB" VARCHAR(16777216), delete_source_entry("P_DB" VARCHAR(16777216), "P_SOURCE" VARCHAR(16777216))

delete_source_entry("P_DB" VARCHAR(16777216),

delete_source_entry("P_DB" VARCHAR(16777216),
"P_SOURCE" VARCHAR(16777216))

Delete metadata entry for source schema, either a single one or for entire database

Parameters:

P_DB → Database
P_SOURCE → Name of the source schema