Explain the difference between Load Look up and Array?
Submitted by: AdministratorLoad Lookup is essentailly an array which acts in the form of a table. Load Lookup is used to reduce the complexity of joins - it populates the values of a certain field depending on the ke field specified from a certain table. Then the users can query from the preloaded lookup table instead of joining tables.
While arrays are used to store and retrieve data using the get and put commands
Apart from above mentioned advantages,Load Lookup increases the performance as it loads an array into memory with key and return value.
Submitted by: Administrator
While arrays are used to store and retrieve data using the get and put commands
Apart from above mentioned advantages,Load Lookup increases the performance as it loads an array into memory with key and return value.
Submitted by: Administrator
Read Online SQR (Structured Query Reporter) Job Interview Questions And Answers
Top SQR (Structured Query Reporter) Questions
☺ | Tell me What is search Record? |
☺ | Can you explain Outer join, inner join in sql? |
☺ | Explain the difference between Load Look up and Array? |
☺ | How to generate tow output files from one SQR? |
☺ | Explain difference between BI, CI, IB? |
Top PeopleSoft Categories
☺ | PeopleSoft HRMS Interview Questions. |
☺ | PeopleSoft Financials Interview Questions. |
☺ | Peoplesoft Security Interview Questions. |
☺ | Peoplesoft Tools Interview Questions. |
☺ | PeopleSoft Common Interview Questions. |