You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

What is staging table? how it is useful?

14 replies [Last post]
Guest's picture
Guest

Hi,

Can any body help me out in knowing about d=staging table and its use?Explain with one scenario if possible.

Thanks in Advance.

Regards,
Kishore

kumar's picture
kumar (not verified)
Re: What is staging table? how it is useful?

Staging table: Staging table is an physical table like state record. It has suffix with "_stg". It is used for doing manuplations.

Nitin's picture
User offline. Last seen 2 years 3 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: What is staging table? how it is useful?

Staging tables are the interface tables to thirdpary or different modules.
Data will be inserted in those tables and then we need to have some process to validate those data and if validated sucessfully we insert that data into PeopleSoft tables.
For e.g.
In Inventory, we can have 3rd party to pack and ship the material.
So 3rd party will provide the shipping information which will be published and staged in staging tables.
Then that data will be validated and correct data will be inserted in PeopleSoft Inventory table.

Cheers
Nitin

Guest's picture
Guest (not verified)
Re: What is staging table? how it is useful?

Hi Nitin,
how to insert staging table data to job record using AE and CI.
Can u provide me any code.

Thanks in advance.

gaurav nanda's picture
gaurav nanda (not verified)
Re: What is staging table? how it is useful?

In its simplest form, "staging" involves putting something in a specific location to be accessed at a later time. All like items will be staged in the same location. For databases, the most common staging location would be a database table. Maybe an example can help illustrate why we would use staging.

Let's assume we are working on a website to obtain orders from our customers. Our customer shops for items on our website and then places their order. At the end of the order, we confirm their credit charges and then display webpage indicating the successful status of their order. The next thing that normally happens is that we email the customer a copy of their order. But waiting for an email server can cause an unacceptable delay in displaying the order confirmation. So we stage the email confirmation in the table. Instead of actually sending an email to the user during their order process, all we do is INSERT one row containing the order_id into the email staging table. If we have many simultaneous users, the email staging table can contain many rows, one for each order. Every five minutes, a scheduled job looks in the staging table to see if it needs to send out order confirmation emails. If the table contains data, it formulates the email and sends it out. The job then removes the entry from the staging table.

With the staging table, we do not need to perform the action right now. We will get to the action later. So the table contains entries for that action.

Courtesy: Internet

Guest's picture
Guest (not verified)
Re: What is staging table? how it is useful?

Thanks gaurav nanda. Thanks was helpful information.

Guest's picture
Guest (not verified)
need peoplecode

i need peoplecode i have a normal table and stagging table and check box on a page vn i click the check box the data should come from normal table to stagging table i need how to write the peoplecode and event is Copmonent Record Filed Event (FIeld Edit , Field Change)
Plz help me frenz

spha's picture
spha (not verified)
SQL Developer does not return query result for this view...

I am having a weird problem. I have one query which provides me some records from my database . I use Oracle Sql developer or Toad as database tool, the problem is with the results. When I run the same query directly from different machine then it displays complete results, therefore I can say that query has no problem. But when I run the same query with SQL Developer then it does not provide me any result, and shows one empty row. Please help me I am running on Oracle 10g.

this is a view select * from okc_k_headers_all_v

Guest's picture
Guest
Re: What is staging table? how it is useful?

Appreciate gaurav's explanation, Thanks a lot for Posting .

Guest's picture
Guest
Re: What is staging table? how it is useful?

Gaurav's reply was very helpful.

Guest's picture
Guest
Re: What is staging table? how it is useful?

Gaurav Nanda's explaination is good

Guest's picture
Guest
Re: What is staging table? how it is useful?

Gaurav, I am new in this field and I am sure even layman can understand what is staging by reading through your example. Thank you very much :-)

Guest's picture
Guest
Re: What is staging table? how it is useful?

where will create staging tables in teradata ? i mean what is the staging tables default database

Guest's picture
Guest
Re: What is staging table? how it is useful?

Greetings!!!

Quick questions on Staging tables

1) Are Staging tables compatiblie with SunSystems 433. ? Can we it for connecting with external applications
2) DO we need SSC to establish the connection between Staging tables and Sun 433

Guest's picture
Guest
Re: What is staging table? how to create it

need syntax

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
1 + 17 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.