61⟩ What is the performance tuning of SQR?
1. Use Load-lookup and Arrays
2. Use SQT files.
3. Generate multiple reports.
4. Use correct sql joins.
Peoplesoft
Home Management Peoplesoft
“Peoplesoft Interview Questions and Answers will guide us now that PeopleSoft Inc. was a company that provided human resource management systems (HRMS) and customer relationship management (CRM) and manufacturing, financials, enterprise performance management, and student administration software solutions to large corporations, governments, and organizations. The Oracle Corporation acquired PeopleSoft,Inc. Learn basic and advance concepts of PeopleSoft with our Interview Questions and Answers.”
167 Peoplesoft Questions And Answers
62⟩ What are the differences between AE and SQR?
AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool.
63⟩ How do you delete a file using sqr?
delete($filename)
64⟩ Tell me your experience with CI?
CI's can be used to upload data from legacy systems through excel to CI or create new data within PeopleSoft from another component.
65⟩ Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the syntax__________.
Trigger Business Event (BusProcess, BusActivity, BusEvent);
66⟩ What is record, row peoplecode?
Record peoplecode is triggered whenever you deal with the record. EX when u right a piece of code on Record Field change that code is fired whenever the Field is changed in any page. There is nothing called Row PeopleCode.
67⟩ What is the difference between SaveEdit and FieldEdit?
Field Edit Validate particular field only, but Save Edit validates all the fields in that component.
68⟩ The following is an entry from the application reviewer LOG File start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233. What does the Source= 233 parameter in the above LOG file entry identify?
The statement being executed is line 233 of the PeopleCode program.
69⟩ What the following command will do? (Psadmin -p start -d hrdmo)
Starts a Process Scheduler
70⟩ What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
71⟩ What is the difference between sql statements and metasql statements?
SQL statements are Database specific whereas meta-SQL statements are Db independent.
72⟩ What are the different ways to run AE, SQR? (Command, process scheduler)
2-tier, 4-tier, process scheduler
73⟩ What category of commands can be executed in data mover?
Sql, data mover commands
74⟩ The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
True
75⟩ How do you retrieve a value from scroll.scroll select?
Scrollselect (1, targetname, recordfiledname)
76⟩ Which of the Task cannot be done through PSADMIN?
Starting Web Server
77⟩ How do you set up table sharing in PeopleTools applications?
SETID
78⟩ How do you decide between appeng/Ci and SQR while conversion?
When you want to validate data upfront before loading them into db, better plan to use appeng or ci, when you are thinking of huge data to be loaded SQR would be a better option
79⟩ What is the event that fires after all database updates?
Save post change
80⟩ The example below demonstrates the use of SQR flags in the configuration manager directories folder -F CPSHrmsSqr What do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
