Google BigQuery Connectors

Back Next

Setting default column value for the lookup and output ports

In cached and connected Lookup transformation, you can set the default column value for the lookup and output ports. When no matching field is found for the lookup query, the default column value is inserted to the output table.

To set the default column value, select the

Use Lookup Field Default Value

option in the Lookup advanced properties.

Consider the following rules and guidelines when you set the default column value:

If you do not set the value, the lookup query inserts NULL when no matching field is found.

When you use the string data type, enclose the string within single quotes.

When you use an expression function as the default column value, do not enclose the function within single quotes.

When you use the byte data type, specify the value in BASE64 encoded format using the DEC_BASE64 function.

When you use the datetime data type, specify the value in MM/DD/YYYY HH24:MI:SS.US format. If you use any other format, provide the value using the TO_DATE function.

You cannot use standard or legacy SQL custom queries as the default column value.

When a mapping writes to an existing target table in hybrid connection mode, you cannot use the record data type as the default column value.

Rename Saved Search

Table of Contents

Google BigQuery Connectors

Google BigQuery Connectors

Setting default column value for the lookup and output ports

Setting default column value for the lookup and output ports