Stage table [message #211059] |
Tue, 26 December 2006 00:29 |
sridharbireddy
Messages: 25 Registered: September 2006
|
Junior Member |
|
|
what is exact Purpose of stage table? without stage table I Insert data into apps tables by using plsql Procedure what happened.
|
|
|
Re: Stage table [message #213676 is a reply to message #211059] |
Thu, 11 January 2007 16:54 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
You can insert directly in interface table (even without using temporary tables) but you should not insert into base tables. You may corrupt data and Oracle will not support you.
|
|
|
Re: Stage table [message #213705 is a reply to message #211059] |
Thu, 11 January 2007 23:56 |
vin_odks
Messages: 153 Registered: July 2006 Location: -
|
Senior Member |
|
|
Basically stage tables are used in conversion and/or migration.
These tables are used to collect data and validate data .
1) It is always a good practice to validate the data before you populate the oracle interface table..since one can minimize the errors in the interface table when an standard oracle program is run.
2) Also data collected may not contain all the necessary id's and data used for the oracle interface table. So one could generate them in the stage table.
3) There is no harm in directly populating the base table if the interface table is not available.One needs to be careful while doing so, since chances of oracle populating more than one table are possible.
The flow of data is as follows
Data source --> Stage table --> Oracle Interface table-->Oracle Base table
Regards
Vinod
|
|
|