Forum Discussion

juergzbinden's avatar
juergzbinden
New Contributor II
13 hours ago

Data Import Step - Load validated records

We are looking for a load into a financial cube. Mappings are already done in the source system. Is there a way to load records that pass the validation and write the other records to an error protocol.

The idea would be that not the whole load is rejected but only records that contain errors, those being written to an error protocol.

Many thanks for your support

Data Integration

1 Reply

  • rhankey's avatar
    rhankey
    Contributor III
    4 hours ago

    I think the best way to handle this would be with an TransformationEventHandler event handler that steps in upon completion BREventOperationType.Transformation.ParseAndTrans.WriteTransformedData.  Go through the transformed rows, and for those rows containing an invalid member, write it to your "error protocol" and either delete the transformed row or update the invalid transformed member to (bypass).