Chapter 35. Lookup Tables

When you are working with CloudConnect Designer, you can also create and use Lookup Tables. These tables are data structures that allow fast access to data stored using a known key or SQL query. This way you can reduce the need to browse database or data files.

[Warning]Warning

Remember that you should not use lookup tables in the init(), preExecute(), or postExecute() functions of CTL template and the same methods of Java interfaces.

All data records stored in any lookup table are kept in files, in databases or cached in memory.

As in the case of metadata an database connections, also lookup tables can be internal or external (shared). You can create them in two ways.

Each lookup table can be created as:

Types of lookup tables are the following: