Lookup Tables
Lookup tables are useful for mapping data, such as the country codes between two applications.
These lookup tables are created at the global level. As such, the following need to be considered:
- When naming lookup tables, prefix with the integration codename.
- Comma-separated values (CSV) import is supported.
- Lookup tables can be referenced from within a recipe.
- Whenever possible, use bulk inserts and updates when writing data to lookup tables to avoid performance issues.
Note: Unionpoint lookup tables support up to 10 columns and 100,000 rows.
Related Links
Parent Topic: Concepts