Yellowbrick Data Warehouse Connector

Back Next

Rules and guidelines for sources and targets

Consider the following rules and guidelines when you read from and write to Yellowbrick Data Warehouse:

When you write to Yellowbrick that has rejected rows and click the

Preview Error Rows File

link, the activity log does not display the records.

When you view a mapping task, the Enable target bulk load entry does not apply to the Yellowbrick connector.

You cannot add custom properties under Advanced in a mapping task configuration.

Time values only preserve millisecond precision. If Time columns in Yellowbrick contain higher precise fractional seconds, the extra precision beyond millisecond is discarded.

Date and Timestamp values with dates before October 15, 1582 are not handled correctly.

The error message appears incomplete when the “Bulk Duplicate Handler” values are not valid.

The error message reads,

yb.load.duplicate_handler must be one of NONE | RANDOM | ORDER BY <sql clause>

first and last should also be included in the error message as valid values. As a workaround, you can correct the syntax of the Bulk Duplicate Handler value.

The statistics for affected rows in bulk update, delete, and upsert is not accurate.

For example, in a delete operation with 26 source rows, only 20 rows match existing rows in the target table.

Rename Saved Search

Table of Contents

Yellowbrick Data Warehouse Connector

Yellowbrick Data Warehouse Connector

Rules and guidelines for sources and targets

Rules and guidelines for sources and targets