Can you please explain the difference between temporary table and SQL view in peoplesoft?
Submitted by: MuhammadTemporary 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.
Submitted by: Muhammad
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.
Submitted by: Muhammad
Read Online Peoplesoft Tools Job Interview Questions And Answers
Top Peoplesoft Tools Questions
| ☺ | What is application package? |
| ☺ | PeopleSoft tools interview questions part 1: |
| ☺ | How to taken care performance management in People Tools? |
| ☺ | PeopleSoft tools interview questions part 2: |
| ☺ | Explain TREE MANAGER? |
Top PeopleSoft Categories
| ☺ | PeopleSoft HRMS Interview Questions. |
| ☺ | PeopleSoft Financials Interview Questions. |
| ☺ | Peoplesoft Security Interview Questions. |
| ☺ | Peoplesoft Tools Interview Questions. |
| ☺ | PeopleSoft Common Interview Questions. |
