Finding a solution to loading several lookup tables into package for reuse several thousand times
Currently I have a large package built that makes several thousand calls to ten different tables (look up tables) to validate data before populating it into core tables. Instead of going back and forth to each table for each record is there a way I can load the ids and codes for each table into the package itself or memory? The query is pulling back the ids based on the codes I send. Any help will be greatly appreciated. Thanks in advance!
0