Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introduction to Databricks Delta Connector
  2. Connections for Databricks Delta
  3. Mappings and mapping tasks with Databricks Delta connector
  4. Databricks Delta pushdown optimization (SQL ELT)
  5. Data type reference

Databricks Delta Connector

Databricks Delta Connector

Multiple match options in lookups

Multiple match options in lookups

When you configure a lookup, you define the behavior when a lookup condition returns more than one match. You can return all rows, any row, the first row, the last row, or an error.
The following configurations have multiple match policy restrictions:
  • You cannot parameterize an uncached connected lookup with parameterized prefixes at source.
  • When the data is not matched for an uncached connected lookup, incorrect data is logged in the target.

0 COMMENTS

We’d like to hear from you!