Forum Discussion

juergzbinden's avatar
juergzbinden
New Contributor II
1 month ago
Solved

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 protoc...
  • rhankey's avatar
    1 month 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).