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.