| |
GeekInterview.com > Interview Questions > Peoplesoft > PeopleTools
| Print | |
Question: Temporary table and SQL view in peoplesoft
Answer: difference between temporary table and sql view in peoplesoft |
| August 08, 2008 02:22:16 |
#1 |
| ravi.velchuri38 |
Member Since: August 2008 Total Comments: 2 |
RE: Temporary table and SQL view in peoplesoft
|
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. |
| |
Back To Question | |
