Frequently Asked PeopleSoft Technical Interview Questions and Answers

8/10/2009 No Comment

PeopleSoft Technical Interview Questions and Answers.

1. What is Application Engine?
Answer : It is the tool, which performs, background SQL processing against our application data tables. It is an alternative for COBOL, SQL or SQR
Programs. Other tools such as query tool and mass change generate SQL.

2. What are the parts of Application Engine?
Answer : Application Engine consists of 4 parts.
1. Application: It is a set of SQL statements.
2. Steps: It is the smallest unit of work committed in an application.
3. Sections: Comprises of 1 or more steps
4. Statements: SQL statements like update, insert, delete or select are issued.

3. What is the advantage of using Application Engine?
Answer : The following are the advantages of using Application Engine.

Unlike applications developed using COBOL or SQR, Application Engine applications reside completely within your database. With Application Engine, there are the programs to compile, no statements to store, and no need to directly interact with the operating environment in use. You can build, run and debug your applications without existing People Tools.

Effective Dating
Application sections are effective dated-meaning you can activate/deactivate a section as of a particular date. This enables you to archive sections as you modify them, instead of destroying them. In the future if you decide to revert to a previous incarnation of a section you can simply reactivate it.

SQL / Meta-SQL Support
In addition to writing your SQL within Application Engine, you can also copy SQL statements into Application Engine from SQL talk or any other SQL utility with few – if any changes.
RDBMS platforms have many differing syntax rules – especially in regard to date, time and other numeric calculations. For the most part you can work around this problem using Meta-SQL which Application Engine supports. This language was created to handle different RDBMS SQL syntax’s by replacing them with a standard syntax, called Meta-strings.

With in Platform specific sections
You can also have the ability to call generic portions of SQL statements by using the & CLAUSE function. This means you can write your generic SQL portions just once, and reference them from your different platform versions.

Set Processing Support
Set processing is a SQL technique used to process groups (or sets) of rows of one time rather than one at a time. Application Engine is particularly effective of processing these types of applications.

Object Orientation
Unless designed to anticipate changes in field attributes. COBOL applications may need to be modified when things change. If a developer increases a field’s length, then it may need to be changed in every instance where the COBOL program uses this field as a bind or select variable. This can require a good bit of effort. And, if not handled properly, a change like this can cause confusing errors. For example, if the length of a field in the COBOL is wrong, it may work fine, or you may get an error, or the field may get truncated.
One of the corner stones of People soft functionality is Application Designer. Because of the way it works, most field attributes (type, length and scale) can be specified once, globally. If the field is used on more than one record, it has the same attributes in each of these records.

You can use Data Mover to import/export your applications. This means that you can export an application(s) into a file, and attach it to an e-mail message. Then, the recipient can simply use the IMPORT feature of Data Mover, and the application is ready to run.

4. What is a Cache Record?
Answer : The Cache record (or cache) is a physical People soft record, keyed by process instance that must be created and maintained by the Application Engine developer. This record defines the fields that an application uses to pas values from one SQL statements to another. You retrieve cache field values by the Application Engine and BIND function; you assign cache values using & SELECT.

5. What is unique about panels, which refer to view as opposed to physical tables?

Answer : Panels that refer to views in People soft are not used for insert, update or delete. All fields on these panels are display only.

6. How search records are used?

Answer : Search records are used to search, retrieve and filter data. Search records also define the structure of the dialog box.

7. Where are the search records assigned?
Answer : Search records are assigned to a panel group in a menu.

8. Does the search record for a panel has to be the same as the record being Accessed on the panel? Why or Why not?
Answer : 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.

9. How can a search record dialog box be suppressed?
Answer : A search record dialog box can be suppressed by assigning a search record that does not have search key.

10. What do search views delivered by People soft do besides displaying the dialogBox?
Answer : Search views delivered by People soft are used to implement row level security as well as display a dialog box.

11. What do you need to do to modify the search views?
Answer : To modify a search view, we need to change the record definition and recreate the underlying SQL view.

12. When would you have to alter the tables and modify the panels, in the processof modifying search records?
Answer : You need to alter tables and modify panels, when you modify a search record to include a new field.

13. When will there be two occurs level records in a panel group?
Answer : If you are referring to two different record definitions that share a same high-level key then two-level one-scroll bar can be displayed as stacked scroll bars.

14. In what order does the application processor fill buffer for the panel group?

Answer : The application processor uses occurs level in the panel group to fill the buffer.

15.Differentiate Error V/s Warning statements in People code?
Answer : The error statement issues a message and the condition causing the error must
Be corrected before proceeding. The warning statement issues a message and
The user can proceed without changing any values.

16. Where can you run Jobs?

Answer : The process scheduler can run jobs on the client or a server machine.

17. What restrictions are placed on multi-process jobs?

Answer : A multi process jobs can only be scheduled to run on a server.

18. List the three output destinations available through the Process Scheduler?

Answer : You can direct the output to a printer file and windows screen.

19. Where do you set up default operator / class options for Process Monitor?
Answer : In operator security, using change, process profile.

20. What are the advantages of incorporating Table set ids into People soft applications?

Answer : Table set Ids allow you to share sets of values (codes) in the same prompt table.

21. What fields should be at the top of every search record definition that use table set Ids?

Answer : SET ID is the field that should be at the top of every record definition that uses table set Ids.

22. What is a Record Group ID?

Answer : A Record group ID is a group of record definitions that are Sharing the same set control field.

23. What do you determine using Table set Ids control information?

Answer : Table set ID control information determines how the information should be shared. The Table set ID control panel defines which Table set Ids set control filed code will use for each record group.

24. What are the three types of Maps used by the navigator?
Answer : The 3 types of Maps used by the navigator are..
1. Business Process Map
2. Activity Map
3. Step Map

25. What are the types of layers in Crystal reports?There are 4 types of layers in Crystal Reports. 
Answer : They are..
1. Report Header - In this, we will write title, date, and logos of the company.
2. Page Header – Used to write column headings.
3. Detail – Contains database column values.
4. Page Footer – Used to write page numbers and address.
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer