IGNORE Mappings in SQL
Summary
Error exporting to FCCS when mapping to IGNORE utilizing SQL scriptingContent
Was hoping someone could help with this. I setup Data Load Mapping using SQL script, if the criteria isn't met I have it map to 'IGNORE'. In Workflow all appears to be working (no validation errors and all the accounts are mapped properly) however when I export the data the it errors out saying 'Fetch of Driver Member "IGNORE" failed.' All the data loads properly however the process fails which is unacceptable. I know this was a bug in the past since the VALID_FLAG did not get updated when using SQL scripts which mapped to ignore so I included the code to set
Tagged:
0