Informatica recommends to use a cached lookup transformation for better performance. If you use an uncached lookup, Informatica recommends that you use a Google BigQuery connection in Simple mode and select

Direct

as the

Read Mode

for the Google BigQuery data object lookup operation.

You cannot configure an unconnected lookup transformation in a Google BigQuery data object lookup operation.

You cannot apply the Lookup transformation on a column of Date/Time, Date, Time, or Timestamp data type.

You cannot apply the Lookup transformation on a column of String data type that contains a single quote character.

When you use a Google BigQuery connection in simple mode in an uncached Lookup transformation, you cannot configure a lookup condition on a column of Bytes, Boolean, Record, or Repeated data type.

When you use a Google BigQuery connection in simple mode in a Lookup transformation, you cannot configure a lookup condition for fields of numeric, date, or datetime data types.