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

    Batch Loader

    Ramith
    Ramith Sep 17, 2014 3:04 AM

      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?

      • 871 Views
      • Tags:
        • 1. Re: Batch Loader
          Francisco Amores
          Francisco Amores Sep 17, 2014 8:09 AM (in response to Ramith)

          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
            Ramith Sep 17, 2014 9:24 AM (in response to Francisco Amores)

            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?