RE: What is difference between Load Look up and Array
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
RE: What is difference between Load Look up and Array?
(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
