Peoplesoft Tools Question:
Download Job Interview Questions and Answers PDF
Can you please explain the difference between temporary table and SQL view in peoplesoft?
Answer:
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.
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.
Download Peoplesoft Tools Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me the use of temporary records and state record in application engine? | Explain mandatory property of App.engine? |