2 Replies Latest reply on Sep 17, 2014 9:24 AM by Ramith

    Batch Loader

    Ramith

      When using Batch loader to load files to append to existing data, is there any way to fail the entire data load if there are mapping errors in few rows?

        • 1. Re: Batch Loader
          Francisco Amores

          What do you mean to "fail all data"? to stop the process?

          you can use event script to stop the process if anything you specify happens.

          • 2. Re: Batch Loader
            Ramith

            Yes, if any mapping is missing and autocorrect is not enabled, I want to batch loader to not push any data to my SQL schema since I want to do an append instead of replace and do not want duplications.

            Validation of mapping happens in validate phase but batch loader pushes the data to my SQL during import phase. Is this correct? If so, then how can I ensure that the data that got loaded to SQL during import phase will get deleted if any mapping error occurs during Validate phase?