1. Staging table : The tables are created manually in oracle database to insert/store the flat file data. Staging table is basically a physical table like state record. It has a suffix like "_STG". It is for doing manipulations. Data will be inserted in those tables and when we need to process some validate those data and if validated successfully, we insert that data to oracle Interface tables or Oracle Base (standard) tables.
2. Interface table : These are the tables which are present by default in the oracle database. The data from the staging tables after validations are moved to the Interface table. For example, GL_INTERFACE table.
The data are entered in interface tables either manually through SQL queries or by PLSQL programs.
3. Base (Standard) table : These are the standard tables present in oracle database. To store data from interface table to base table, we need to run oracle standard requests, for example "GL_IMPORT_JOURNALS".
4. Error table: These are the least priority table in oracle table. After validation in staging table, the failed data the allowed to stored in error table.
2. Interface table : These are the tables which are present by default in the oracle database. The data from the staging tables after validations are moved to the Interface table. For example, GL_INTERFACE table.
The data are entered in interface tables either manually through SQL queries or by PLSQL programs.
3. Base (Standard) table : These are the standard tables present in oracle database. To store data from interface table to base table, we need to run oracle standard requests, for example "GL_IMPORT_JOURNALS".
4. Error table: These are the least priority table in oracle table. After validation in staging table, the failed data the allowed to stored in error table.
No comments:
Post a Comment