1. Why do we have multiple state records?
We try to group the related variables into state records, this way the app engine will be better structured, rather than when we have all variables in one state record.
2. What is the difference between component buffer and data buffer?
Component buffer contains the data pertaining to the presently active component, whereas the data buffer can contain the data which is related to the presently active peoplesoft application on the whole, it may belong to the component or application engine or can just be a message. Rowset 0 when formed data of component buffer will have only one row in level 0, where it has child rowsets. The rowset 0 when formed from data buffer data can have multiple rows of data.
3. In what file formats can the file layout be specified?
ñ Xml file.
ñ csv file.
ñ fixed length files.
4. What are the different server on which you can apply the performance tuning actions? Which servers get the connectivity software?
You can do the performance tuning with the Application server, batch server, database server and the Web server. The connectivity software can be installed for the Application or the scheduler servers if not over the database server.
5. What are the restrictions over the translate table?
The translate table can contain elements of only up to 4 bytes (4 characters) length. There can only be 30 entries maximum entries in the translate table.
6. What will happen if we have a callsection run when there is SQL action already running?
This condition will lead to a deadlock, as the database on which the SQL actions are running will have the locks enabled over the tables and if more processes are triggered from the callsection to access the various tables that are under lock, the processes will fail and the application is said to be in deadlock.
7. How will you go about upgrade of the peoplesoft tools?
The upgrade should be first planned then production database has to be backed up. The new release can then be installed and peopletools can be upgraded. After this the application changes can be applied. The reports that are generated are validated and then production copy is put in place.
8. Can we install the two versions 8.1x and 8.4 of peopletools on the same machine?
The installation is allowed and is possible to have multiple versions on the same machine. The only thing we have to make sure is there are no port collisions between the two, so assign unique ports and both the installations should be working fine.
9. What is ERP and what is SAP?
ERP stands for Enterprise Resource planning and they represent the software that helps in the management of the enterprise as a whole unit. Normal management focuses on specific domains like finance, human resource etc. But ERP tools give the totality of management. The SAP is the company that is well known for their management software, which offer the complete business management solution.
10. What is a section?
Section refers to a specific set of ordered instructions, which are executed as an integral part of the program. Sections can be called from other sections just like functionalities.
11. What are various values that can be given to the peopleCode debugger?
ñ View Variable Value.
ñ Go – for continuing execution.
ñ Step over – To step to the next possible point of check.
12. What is meant by Activity type?
Activity type refers to the nature of the activity, in other words the various aspects of the environment and the context of action that is carried out is depicted as the activity type.
13. What do you mean by GAP analysis?
GAP Analysis refers to the analysis of the deviation of the performance of the system from the ideal or standard system. Thus this is nothing but the difference between the expected output and the actual output.
14. How are metaSQL statements different from the normal SQL statements? Where are these stored?
The metaSQL statements act over the entire database and is usually independent of the database over which it is called, the SQL statements are dependent on the database. The metaSQL statements offer the high level organization of the database while SQL statements retrieve the values from the specific RDB. The metaSQL statements are stored in the temptable, Sql table or the Query table.
15. What are the various events related to the record field in PeopleCode?
The various events are FieldEdit, RowDelete and the SaveEdit.
16. Can we use the IBM WebSphere on the 8.1x versions of the PeopleTools?
IBM Websphere can be used with 8.1 even though it comes as a certified addition only from the PeopleTools 8.4. This can be done by registering into the Early Adopters Program if IBM.
17. How can you setup a table-sharing in the PeopleTools application?
The SETID can be added as a keyfield in the tables that need to be shared. Then setting the appropriate control fields in the SETID field will enable sharing across applications.
18. What are the various views that are offered by the Application Designer Project Interface?
ñ Development view.
ñ Upgrade view.
19. What are the ER diagrams?
ER diagrams stand for portraying the Entity Relationships, which bring out the various business functions and processes. The various tables and the fields involved are also brought out in the relationship specifications.
20. What are dynamic views?
When we do not want to store the database values that are being used, then we take up the dynamic views. They are similar to SQL views but the difference being, they are not built explicitly.
21. What record changes can occur without affecting the database?
Dynamic view record change, Derived work record and subrecord changes do not reflect upon the database.
22. What is application messaging?
Application messaging is the mechanism by which the peoplesoft applications communicate with each other. The HRMS application can send/receive messages to/from the finance management app. This type of message passing can go across various versions of the people soft. The more and more messages are identified to be published, more and more are made available as recognized messages for the customers.
23. Differentiate rowset and rowclass.
A rowclass is an object that is representing a single row with n elements of data whilst the rowset is a data structure that is used to present a hierarchical outlook of the rows. It contains many rows of data.
24. What is the difference between fieldEdit and saveEdit of a component?
The FieldEdit sees the validity of the specific Field during update but the saveEdit checks for the validity of the data of entire component during the update process.
25. What are the various components of Interface Broker?
ñ Application messaging.
ñ CI.
ñ File Layout.
26. What is the command to start the process scheduler from command line?
“$psadmin -h start -d hrdmo “ This will start the process scheduler.
27. What is a subpage?
The subpage refers to the entity that helps in displaying or capturing a generic set of parameters. This set can be used by many different attributes. For example, if we have the sales report of a company and the sales report of the specific branch, both are going to display the data in similar way in the page and also are going to be captured same way from the data. This commonness is implemented in the form of a sub page.
28. Compare SQLExec and CreateSQL.
The SQLExec contacts the physical database directly to retrieve the data that is being asked for. The retrieval is done on a row by row basis. The bulk retrieval or bulk update is nor possible with SQLExec. The CreateSQL on the other hand involves the bulk access of data whether its update or insert.
29. What is the App. Designer interface?
This is the IDE used for developing of Peoplesoft applications. It offers interface to generate and design tables for the Db, design the web pages, to control the flow control within the application and also interface for security implementations. The PeopleCode implementations are better with the App designer interface and is made simpler.
30. How do the run control Ids help?
The parameters that you use for generation of a report are mostly remaining the same through time. The run control id depicts the database record that is meant for the storage of the parameters that are configurations for the report generation. So once the record for control id is saved all future executions and report generations can use the already saved parameter settings.
31. What is the maximum depth of array and what are the functions for adding elements to array?
The maximum depth of the array structure in peoplecode is 15 dimensions. The functions are unshift and push. The unshift adds the element to the beginning of the array and the push adds it to the last. The pop is used to take out the element from the end of array. It will also delete the selected element.