Tag: databases

A process to reject data from the data warehouse and to create the necessary indexes

A process to load the data in the data warehouse and to create the necessary indexes

A process to upgrade the quality of data after it is moved into a data warehouse

A process to upgrade the quality of data before it is moved into a data warehouse

A process to change data from a detailed level to a summary level

A process to change data from a summary level to a detailed level

Joining data from one source into various sources of data

Separating data from one source into various sources of data

Converts data from one field into multiple fields

Converts data from multiple fields into one field

Converts data from multiple fields into multiple fields

All of the above

Many-to-many

One-to-one

One-to-many

All of the above.

Completely demoralized

Partially demoralized

Completely normalized

Partially normalized

Fact

Dimension

Helper

All of the above

To explain some observed event or condition

To confirm that data exists

To analyze data for expected relationships

To create a new data warehouse

Run the AD Relink utility and relink the GL product

Use License Manager, and register the GL product.

Run the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility

Run Autopatch, and apply GL latest available patch

Run Rapid Install to reinstall the database components

<db_name>DB

<db_name>ORA

<db_name>COMN

FND_TOP

APPL_TOP

before performing an export/import

immediately after an upgrade or applying a maintenance pack

converting to multiple organizations or multiple reporting currencies

after a patch or multiple patches are applied

whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package