Home » Applications » Oracle Fusion Apps & E-Business Suite » What does 'staging tables' mean?
What does 'staging tables' mean? [message #194600] Fri, 22 September 2006 20:32 Go to next message
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 Go to previous messageGo to next message
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
icon7.gif  Re: What does 'staging tables' mean? [message #195455 is a reply to message #194620] Thu, 28 September 2006 15:48 Go to previous messageGo to next message
mihirca
Messages: 6
Registered: September 2006
Junior Member
Thanks a lot...
Regards
Mihir
Re: What does 'staging tables' mean? [message #195501 is a reply to message #194600] Fri, 29 September 2006 01:42 Go to previous message
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
Previous Topic: PO Approval Hierarchy
Next Topic: Oracle WEB ADI
Goto Forum:
  


Current Time: Wed Dec 07 12:52:29 CST 2016

Total time taken to generate the page: 0.13261 seconds