Transformation Fail on Zero (0) Writes

  • Posts: 465
  • Karma: 2
  • Thank you received: 43

Transformation Fail on Zero (0) Writes was created by bruce.gibbins

Hi.

I may have missed this option if it already exists. But I was wondering if there was an option to have a Flag on the Transformation Action in a package that would throw an 'Error' if there were records processed but nothing written?

In my case we get an inbound source file that is then filtered via a Validator with unmatched rows being DISCARDED in a Transformation. On occasion this results in no valid records being found and thus nothing written. The Transformation completes with no Error and nothing actually went wrong at our end except that they sent us a file that was missing the data we needed. We should still investigate.

The workaround at the moment for us is to interrogate the <Transformation Processed> and <Transformation Error> After Execution variables but just thought it would cleaner and in our case a bit more intuitive to have a simple flag that can then force the Transformation o end in error. Then the rest of the package flow would not have to jump into scripts to check for values and change workflow control from that point.

Cheers

1 month 1 week ago #21490
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8349
  • Karma: 33
  • Thank you received: 549

Replied by admin on topic Transformation Fail on Zero (0) Writes

Good Idea we will have a look at it for you
Mike
ETL Architect
1 month 6 days ago #21496

Please Log in or Create an account to join the conversation.

  • Posts: 1199
  • Karma: 3
  • Thank you received: 151

Replied by Peter.Jonson on topic Transformation Fail on Zero (0) Writes

Hi Bruce

Your suggestion was implemented in the latest release.

Peter Jonson
ETL Developer
The following user(s) said Thank You: bruce.gibbins
1 month 6 days ago #21497
Attachments:

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies