Interview Questions.

Q1. What Are Different Types Do Select?

Select/Fetch: Opens the cursor simplest at the first time and retrieve rows one at loop

Reselect: It opens the cursor and closes the cursor on every new release of the loop. It will reselect the same row of data. Logic in Actions of the step should be such that it will likely be changing the repute of the rows inside the desk the do pick is deciding on. Commits are not unnoticed and will be dedicated in a reselect loop when the restart is enabled

Restart able: much like pick out/Fetch however it WILL COMMIT within the loop hence permitting the checkpoint to the PS_AERUNCONTROL table.

Q2. What Are The 3 Common Ways To Pass A Trace Parameter And Value To Your Program Psae.Exe?

The three common ways to skip a hint parameter are the following:

Configuration supervisor

Process Definition

Command spark off

Q3. What Is Prerequisite For The Temporary Record?

Should have system Instance as key

Name ought to cease with _TAO

Q4. What Are Different Types Of Variables In The Application Engine Peoplecode?

There are two varieties of Variables specially in Application Engine Peoplecode, they're:

Local variable – These are the variables available throughout the program wherein they may be declared.

Global / Component – These are the variables to be had at the same time as the Application Engine application is running. They get stored at commits and check points, so they may be used for restarts. Component variables are equal as Global in case of the AE.

Q5. Different Ways Pass Data Between The Steps?

We can bypass information among steps in 3 different methods, they're:

Using State information – One row may be handed and might have many state records.

Using Component/Global People code variables

Using Temporary facts – Multiple rows of information can be exceeded.

Q6. What Is The Syntax For Callappengine?

The Syntax for CallAppEngine is as under:

CallAppEngine (applid [, state record]);

Q7. What Are The Important Steps For Implementing The Parallel Processing?

Define you Temporary Tables.

Set the Temporary Tables Online pool.

Assign Temporary Tables to your Application Engine software in it application.

Set Temporary Table Batch Pool – Instance count number within the AE.

Build / Rebuild your Temporary Table file.

Code %Table Meta – SQL as reference to Temporary Tables in your Application Engine application,

in order that Application Engine can desk references to the assigned Temporary Table example dynamically at runtime.

Q8. Which Actions Are Mutually Exclusive And Why They Are Mutually Exclusive?

Sql and callsection.

Q9. How Do You Program Ae Program For The Restarts?

Program Level:

State Record: One of the country file desires to SQL Table, Since All Derived work document might be re-initializing on commit.

Program Properties: On the Advanced tab inside the application houses dialog box, make sure that disable restart isn't checked

Configuration supervisor: In the configuration manager, sure that Disable restart isn't always decided on at the manner scheduler tab.

Section Level Section type:

The option for segment type are prepare most effective and crucial updates

If the segment is making ready information i, e choose statistics, populating brief tables, or updating temporary tables then the section must be put together best

If the section is updating the everlasting software tables in the database, you should pick crucial update.

Step Level Add an order by way of clauseThe simplest restrict for batch runs occurs if you have restart enabled, and you are inner a Do Select that is of the Select/Fetch kind (in place of “Re-choose” or “Restartable”). With select/Fetch, all commits inside the loop are left out, which includes the dedicate frequency if it’s set.

Q10. What Happens When All The Instance Of The Temporary Table Is In Use?

It behaviour can control with the aid of AE developer. If the runtime alternatives are set to keep

“People Tools will insert rows into the base desk the usage of the PROCESS_INSTANCE as a key”

If temp desk doesn’t include PROCESS_INSTANCE as a key discipline in a Temporary desk, you ought to trade the

Temp table runtime alternatives to “Abort” in an appropriate Application Engine applications.

Q11. What Are The Different Types Of Temporary Tables?

Dedicated

Un Dedicated (Shared)

Q12. What Are The Different Types Of Application Engine?

In wellknown, the kinds are:

Standard : Standard entry-factor program.

Upgrade Only : Used with the aid of PeopleSoft Upgrade utilities most effective

Import Only : Used through PeopleSoft Import utilities most effective

Daemon Only : Use for daemon kind packages

Trform Only : Support for XSLT Trform packages

Q13. How Do You Execute Application Engine Through Push Button?

Application Engine may be execute with a single click on Push Button, by means of the usage of the subsequent:

CreateProcessRequest () , Schedule ()

CallAppEngine.

Q14. What Are The three Trace Parameters You Can Pass To Your Psae.Exe?

As following:

TRACE <trace value>

TOOLSTRACESQL <trace value>

TOOLSTRACEPC <trace value>

Q15. How Can You Divide The Data To Be Processed By Different Instance Of The Program To Perform Parallel Program?

Run manage parameters surpassed to every example of the AE software permit it to become aware of which input rows “belong” to it, and every program example inserts the rows from the supply desk into its assigned temporary desk example using %Table.

Q16. Explain The Order And Flow Of Action Types?

Do When

Do While

Do Select

Peoplecode

SQL

Call Section

Message Log

XSLT

Do until

Q17. How Running Ae Program As Batch Differs From Running It Online?

Application Engine applications are designed for two types of execution and every has its very own pool of Temporary Tables

Online: Invoked with the aid of CallAppEngine from People Code Run speedy, synchronously, and at random instances. Potential for simultaneous executions Uses the net Temporary Table pool. Not restart capable. Psae.Exe randomly assigns an example variety from the number variety in your on line temp tables. If the example number is in use psae.Exe places this system in Queue till the assigned instance will become loose. Unlock on completion, on Crash unfastened from Manage Abends.

Batch: Invoked thru the Process Scheduler. Run for longer amounts of time, asynchronously, and at scheduled instances. Can be designed for parallel execution for overall performance. Uses the Batch/Dedicated Temporary table. Restart in a position. It allocates example variety based totally at the availability on a report with the aid of report basis and psae.Exe begins with the bottom instance numbers. If the residences are set keep – Base table is used with Process example as key. If Re-startable – Locked throughout Restarts until completes efficiently. If no longer Re-startable on Program of completion.

Q18. Explain Set Processing?

Set Processing uses SQL to system businesses, or sets, of rows at one time rather than processing each row for my part. With row by row processing you following a repetitive loop that selects a row, determines if it meets a given criterion, in that case, practice rule x to row Update row, devote. With set processing, you best pick the ones rows that meet the filtering criteria after which run the guideline once again all the affected rows.

Q19. What Is Prerequisite For The State Record?

To use state record, there are certain stipulations, they're:

State Record need to be a SQL Table or a Derived work document, for AE Restarts we'd absolutely want State Record as a SQL Table, as Derived work statistics shop data best at run-time.

Name of the State Record must end in AET, the system identifies the document as a state report with this notation

We want to apply PROCESS_INSTANCE subject within the file and it have to be described as a key

Any facts types except character or numeric have to not be required fields

Q20. Explain About Testing And Debugging Application Engine?

Application Engine Trace File-You can track the step execution of your application execution

Application Engine Interactive Debugger – First click on at the trace tab and turn off the assertion timings.

Select Profile -> Edit Profile-> Process Scheduler Tab -> Application segment Select Debug check box.

(You can dynamically alter the kingdom record run utility engine grade by grade People Code Debugger for the Application Engine.)

AE Trace files: – AE_<Program Name>_<Process Instance>.AET Without the technique instance: – AE_<Date/Timestamp>_<OS_PID>.AET

Q21. How To Read The Run Control Parameters In Ae?

There are many methods of reading run-manage parameters in AE, maximum commonly used are:

SQL:

%Select (EMPLID)   /*This will pass price to State report*/

Select EMPLID from PS_AERUNCONTROL where PROCESS_INSTANCE = %PROCESS_INSTANCE and OPRID= %OPRID

People code:

&SQL = “Select EMPLID from PS_AERUNCONTROL Where PROCESS_INSTACNE = RECORD.PROCESS_INSTANCE and OPRID = %Bind (PROCESS_INSTANCE)

Q22. What Is The Difference Between A Trace Value And Trace Parameters?

A Trace parameter determines which kind of trace is turned on.

A Trace value determines what sort of facts is recorded in your trace files.

Q23. Error Handling Or Exception Handling In Application Engine?

Step properties:-

On Error: –

Abort – Write message to message log and terminate.

Ignore – Write message to message log and hold.

Uppress – No message might be written, but software will keep.

People code Action: –

On return options can used to deal with run time mistakes.

Abort: – Exits right now – Not encouraged.

Break: – Exits the current step and section and control returns to the calling step.

Skip Step: – The software exits the current step, and keeps processing at the next step inside the section. If that is the remaining step inside the section, the calling step resumes control of the processing.

SQL Action residences: –

No Rows: – When the Sql doesn’t return any rows, you can tell what utility engine application must do.

Abort: -Program terminates Section Break: -Application Engine exits the present day section right now, and manage returns to the calling step.

Continue: – The application keeps processing Skip Step: – Application Engine exits the present day step straight away and movements directly to the following step.

When the usage of pass step maintain the subsequent in thoughts:1) Application Engine ignores the commit for the modern-day step at runtime2) If the cutting-edge step carries simplest one Action, only use bypass step at through-skip the dedicate.

Q24. What Is The Main Purpose Of The Access Property In The Section?

Basically they have got  choice, public and personal if phase declared as public then it's access from other program. Private we can not call from different software.

Q25. Why Parallel Processing Required?

Multiple temporary tables as a pool of tables can be helpful to achieve parallel processing. Each invocation of your program would need to allocate an unused transient desk, mark it as ‘in use’, use it and release it back to the pool when you thru with it (for every Application Engine application you write).

Q26. Trace Parameter Mostly Used For General Performance Information?

TRACE <trace value> 384 – generally used hint price.

Q27. What Is The Difference Between Exit (zero), Exit (1) When We Are Using This Functions In Ae?

Exit (1) reasons immediately termination of a Peoplecode application. Use this parameter to rollback database changes.

Exit (zero) prompted on the spot termination of a Peoplecode Program however don’t make rollback inside the database.

Q28. What Is The Maximum Limitation On Temporary Table Instances In Ae.?

99

Q29. What Is The Difference Between The %choose And %selectinit Meta Sqlfunctions?

%pick out: if any values have no longer decided on then previous cost might be there

%selectinit : if any values have now not selected then preceding price will reinitiate to null

Q30. What Are The Advantages Of Set Processing?

Improved Performance: – Set processing performs extensively higher than it's far -through-row counterpart for “reasonable” batch processing volumes.

Minimized SQL Overhead: – It has a tendency to apply fewer Application Engine SQL statements that each processed more information than the statements completed in row-by using-row processing.

Easy Maintenance: – if need to make a restore or add an enhancement to SQL, it’s just a count of editing the SQL or placing the brand new “Chunk”. Leveraging the RDBMS: – With Set – based totally processing, you're taking advantage of the SQL processing engine at the database rather than putting the processing burden and overhead on the application executable.