Temporary table and SQL view in peoplesoft

Difference between temporary table and sql view in peoplesoft

Questions by Priya21

Showing Answers 1 - 2 of 2 Answers

ravi.velchuri38

  • Aug 13th, 2008
 

Temporary Table: Temporary tables are used for running PeopleSoft Application Engine batch processes. Temporary tables can store specific data to update without risking the main application table.

SQL View: It is not a physical SQL table in the database, but rather fields from one or more SQL tables that are reorganized into a different sequence. This provides an alternate view of information that is stored in tables.

ravi

  • Aug 31st, 2014
 

Temporary Table used to increase the performance of Application Engine(based on batch process or etc ..).
SqlView used to get the data from multiple tables and select statements is manually written

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions