Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews PeopleSoft Interviews:Component InterfaceInternet EBusinessPeopleCodePeopleSoft AdminPeopleSoft AdministrationPeopleSoft BasicPeopleSoft CommonPeopleSoft FinancialsPeopleSoft HRMSPeopleSoft ImplementationPeopleSoft InterfacesPeoplesoft SecurityPeoplesoft ToolsPeopleToolsSQR (Structured Query Reporter)
Copyright © 2018. All Rights Reserved
Peoplesoft Tools Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.