Interview Questions and Answers on PeopleSoft.
1. Define security administrator?Security administrator is used to control and access the various People soft menus.
2. How many types of security administrator profiles? Define?
There are three types of Security administrator profiles:
1. Access Profile: It is an RDBMS ID. It provides the necessary Ids and password for behind-the-scene process.
2. Class Profile: It is defined to organize the users into groups with common access rights or privileges.
3. Operator Profile: It is commonly referred as a Operator Ids or operator having associated sign on passwords.
3. What is Set ID or Table Set?
Set ID shares common control table values.
4. Define Object Security?
The Security profile which is created as an operator security to restrict access to People soft data.
5. Define Object Group?
It is a collection of one or ore objects that form a logical group for security purpose.
6. What are the steps involved in developing a conversion strategy?
The following are the steps involved:
1. Setting Operational Goals.
2. Timing
3. Developing and testing data load routines
4. Mapping your data
5. Performing conversion analysis
6. Evaluating source data
7. Evaluating Target Table.
7. What operations can Import Manager perform?
Import Manager provides a mechanism for converting data from existing files to your People soft application data tables. Record definitions are foundations for Import Manager.
1. Field formats and editing: Import manager is used to upload file data from a designated source file into your application database. The source file containing data to be imported must be a fixed length ASCII file (. DAT FILE)
2. SQL Inserts: The Import manager performs only SQL inserts. This means that new rows of data with a unique key can be inserted into SQL table. Updates to an existing row of data cannot be done through import manager.
3. SQL commit: The SQL commit takes place at the end of each import load. If the import stops before the end-of-life, none of the new rows of data will be written to the database.
8. Will the import manager write data values to the target table if it encounters key values in the source table?
NO – If the utility encounters key values on the source file, error message is flashed and the rows will not be written to the database. To overcome this problem, we will have to enable “by pass key value” control in the Import manager.
9. Options available to run Import Manager?
The following options are available to run import manager.
1. Edit: Read through the rows to imported and processes an edit report of the
Results. No data is written to the database.
2. Load: Writes rows of data to the database and automatically prints an edit report
Summarizing the result.
3. Compare: Reserved for future use. It currently has the same functionality as an
Edit.
10. What is Translate Table?
A translate table is a prompt table that serves as data dictionary to store values for fields that don’t need individual prompt tables of their own.
11. What are the limitations of Translate table?
1. Field type should be character
2. Minimum Field length should be 1 to 4 characters.
3. Field values should be small (static).
12. What is Effective Data?
Effective data is used to store history, Current and Future information.
13. History date Vs past Date?
Past date - Within 30 days of current date is called Past date.
History date - Above 30 days of current date is called History Date.
14. What is a record?
A Group of non-repetitive fields is called a record.
15. How many types of records are there?
There are six types of records
1. SQL table - Corresponding physical SQL table in the database we create with build option.
2. SQL View – It is not a physical SQL table on the database, it gives the replicate of joined tables. It is used for security and faster access.
3. Dynamic View – It is actually stored in the form of SQL view text and is executed at runtime. It uses the built in indexes. Whereas normal view is executed and stored in the database.
4. Derived/Work record - It is a temporary workspace to be used during on line panel processing and is not stored in the database, therefore derived work records are not built. They cannot be seen in the update/display mode. Once the panel is cancelled it is removed from the buffer.
5. Sub Records – A group of fields commonly used in multiple records.
6. Query View – A Query view is a view constructed using People soft Query tool.
16. How many types of Displays are there in the tool bar?
1. Field Display - It shows the filed attributes (fieldname, Type, Len, Format, H, and Shortname, Long name
2. Use Display - It shows key related characteristics and default values for the fields
(Field name, type, direction indicates, search key, list, system indicates, audit, H, default values)
3. Edit Display - It shows the auditing options available for the fields (field name, type required , edit, prompt table, reasonable date, people code)
4. People code display - It shows the different events and the user can choose required event to write people code.
Related Posts
No comments :