Home | Table of Contents | Types of Lookup Tables | CloverETL 4.6.1
--- | --- | ---
Prev | Lookup Tables | Next

## Types of Lookup Tables

After opening the New lookup table wizard, you need to select the desired lookup table type. After selecting the radio button and clicking Next, the corresponding wizard opens.

Figure 34.5. Lookup Table Wizard

Table 34.1.

Lookup Table | Whole Table in Memory | Allows Duplicated Key Values
--- | --- | ---
Simple Lookup Table | Yes | Yes
Database Lookup Table | No | Yes
Range Lookup Table | Yes | No, but intervals may overlap
Persistent Lookup Table | No | Yes
Aspell Lookup Table | Yes | Yes

Prev | Up | Next
Internalizing External (Shared) Lookup Tables | Home | Table of Contents | Simple Lookup Table