What is the difference between sqr and application engine

A smidgeon of good design is worth much more than choosing either tool. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account.

We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Tags: PeopleTools. Anonymous March 10, 0 Comments. Any feedback will be appreciated. Anonymous Posted March 10, 0 Comments. Less time to code through use of components. Allows use of java through PeopleCode to expand tools set.

I'm Existing User New User? Register Now. PeopleSoft Interview Questions. Encapsulation: AE: Can use Application packages, thus bringing in encapsulation and other object oriented programming concepts. Those I will also consider in my evaluation. AE will be minimal. It is just a opinion based on empirical data rather than specific performance tuning experience.

In we had to process a set of three inbound data streams. Based on the combination of Header and Detail flags, one of six things could happen to the data.

The standard programmatic approach Loop through header rows. For each header row loop through detail rows. For each detail row evaluate and process. Was originally written in SQR and took four and a half hours to process. LOG file was effectively stored as rows in the database instead of being written to a file. We then redesigned the whole approach to allow the database to shunt the inbound data into one of six tables based on the combination of the HDR:DTL flags and then ran six parallel processes to process the six tables accordingly.

As everyone else has said SQL set processing is infinitely more important than programmatic tool choice. App engine are easy to maintain from support prospective as it's reside inside Peoplesoft PS applications.

App engine are very systematic to Develop and Debug. SQR are difficult debug. SQR is mainly used to create Reports. By App Engine we can not create reports.

Profile Answers by sriramakrishna. Sqr : 1. No encapsulation 2. No Restart Logic Appl Engin : 1.