Peoplesoft Interview Questions and Answers
Question - 81 : - Steps involved in Data Conversion?
Answer - 81 : -
- Extract data from the legacy system
- Reconcile the extracted data
- Identify the tables to be leaded with the new system
- Data Mapping
- Identify the tools (SQR or Import Manager or SQL Loader etc)
- Write programs to perform conversion
- Test the programs using test data
- Check the data outline
- Reconcile concerted data.
Question - 82 : - Why SQR is used?
Answer - 82 : -
- Data conversion
- Reports
- Interface programs.
Answer - 83 : -
- Create/modify/add run control table if you have any new fields
- Create/modify/add run control page if you have any program inputs
- Create a menu definition (Note Menu group name: XYZ)
- Give operator security
- Create Process scheduler definition
- Use-Process definition – process definition add
- Give report name and report type
Answer - 84 : -
- & Data base reference fields – Read only
- $ Character (Same for Date)
- # Numeric
- { } Variable in ASK or # define
- [$ variable] Dynamic variable referencing
Answer - 85 : -
Dynamic view that can be used like a view in pages and PeopleCode, but is not actually stored as a SQL view in the database. Instead, the system uses the view text as a base for the SQL Select that is performed at runtime.
Dynamic views can provide superior performance in some situations, such as search records and in PeopleCode Selects, because they are optimized more efficiently than normal SQL views.
Question - 86 : - Table loading Sequence (installation)?
Answer - 86 : -
- Company table
- Installation
- Location
- Department
- Salary Plan
- Salary step
- Job code
- Pay group
- Benefit Programs
Answer - 87 : -
It is the tool, which performs, background SQL processing against our application data tables. It is an alternative for COBOL, SQL or SQR
Question - 88 : - What are the Different types of Application Engine?
Answer - 88 : -
- Standard: Standard entry-point program.
- Upgrade Only: Used by PeopleSoft Upgrade utilities only.
- Import Only: Used by PeopleSoft Import utilities only
- Daemon Only: Use for daemon type programs.
- Transform Only: Support for XSLT Transform programs.
Question - 89 : - Where are the search records assigned?
Answer - 89 : - Search records are assigned to a component in a menu.
Question - 90 : - Does the search record for a panel have to be the same as the record being accessed on the panel? Why or Why not?
Answer - 90 : -
The search record for the panel does not have to be the same as the record being accessed on the panel because the search record is used to search for and or Filter the search key.