Jiju

• Jun 8th, 2006

 

Load 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

Bhaskar Boddupally

• Jul 14th, 2006

 

good Answer Jiju

facinater

 Profile Answers by facinater 

• Aug 20th, 2008

 

(1) Load-lookup:-
----------------------
1) Load-lookup will be populated at compilation time
2) We can adjust the size of load-lookup
3)
It is only for text datatype
4) We can only select two fields, but by string
cancatnation we can select more than two fields.
5) Size of the load-lookup will be
increased automatically

(2) Array :-
---------------
1) Array get populated at Execution time
2)
We can't modify size of the Array. if we given more than the size of the array Program automatically aborts
3)
We can select any number of fields we want
4) Array Supports all datatypes