Hits

• Apr 28th, 2005

 

Temporary tables are basically used for the parellel processing and for better performance

wyangw

• May 4th, 2005

 

Defines the record definition as a temporary table. Temporary images of the table can be created, specified by the PeopleTools Options Page. Temporary tables are used for running Application Engine batch processes. Temporary tables can store specific data to update without risking your main application table. 

Vaibhav

• Jun 21st, 2005

 

Temp tables are mainly used for Parrellel processing. Also you take the data you want for manipulation into your Temp table, and you can play with that. Finally when you get the desired data, you can update the main tables.

Shail

• Jul 21st, 2005

 

One important thing, when dealing with temp tables. When you use PeopleCode to call the app-engine, it runs synchronously and also it doesn't use any temporary table instances created for batch processing instead it uses the instances created for online processing which by default is 3.

R.Guru Lakshmi

• Jan 30th, 2006

 

hai We use temp records for batch processing.This temp table can store specific data to update without risking our main application table.

Bineesh

 Profile Answers by Bineesh 

• Jul 19th, 2006

 

temporary tables are used by PF_RESOLVER in EPM. The source data will be resolved based on the run time parameters and inserted into the temporary table instance based on the record suite ID.

Ruchi Bhardwaj

• Aug 21st, 2006

 

AE programs run in batch mode so the multiple instances of the same program gets created and due to this the deadlock situation can come. To avoid this situation peoplesoft provides the concept of temp tables i.e. the data that needs to be updated by the AP program is stored in the temp tables. This avoids the situation where the programs fetches the row one by one, process it, and then send the updated data back. By creating temp tables you can store the data that is effected by business logic in the temp table and then you can perform the opertaions on it instead of the main table. Once the processing is completed you can send the data back to the main table.

nsivudu

 Profile Answers by nsivudu 

• Mar 27th, 2008

 

Temporary table can be used in application engine programs to support parallel processing and better performence