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...
Forum Discussion
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).