What does 'staging tables' mean? [message #194600] |
Fri, 22 September 2006 20:32 |
mihirca
Messages: 6 Registered: September 2006
|
Junior Member |
|
|
Dear All
I am a Finance person and recently associated with ORACLE implementation in our company.
Can someone guide me as to what is meant by a 'staging table'...
I am not an IT person and would not understand a 'technical' answer...
Thanks
Mihir
|
|
|
Re: What does 'staging tables' mean? [message #194620 is a reply to message #194600] |
Sat, 23 September 2006 01:14 |
adragnes
Messages: 241 Registered: February 2005 Location: Oslo, Norway
|
Senior Member |
|
|
A staging table is a table where data is held temporarily for transformation, enrichment and validation before it is moved to the final destination. Staging tables are typically used for conversion and interfaces.
- Transformation includes activities such as changing formats and data types, e.g. the character string "23-SEP-2006" into the date September 23 2006; mapping one value to another, e.g. from 1 to "M".
- Enrichment is adding new data to the records that were not available in the source.
- Validation is checking that the values in fields in a record are valid and that the record is internally consistent.
--
Aleksander Dragnes
|
|
|
|
Re: What does 'staging tables' mean? [message #195501 is a reply to message #194600] |
Fri, 29 September 2006 01:42 |
B.T.S.Ananth
Messages: 216 Registered: June 2006 Location: chennai / Hyderabad
|
Senior Member |
|
|
Hi,
To do business validation(specific to ur requirement) against the data you are loading from flat file before moving that to Interface table. If anything is not satisfying ur checks REJECT it at staging table itself and move only the good records to Interface.
other reason would be, like you want to populate some of the fields from ur database....say you need to have organization_id in interface, you can have organization_code in flat file(as its easy to refer organization code in file rather than organization_id) and after loading the data in staging table you can derive the oraganization if before you insert into interface table..just an example.
Regards,
B.T.S.Ananth
|
|
|