Provide a way for the EXTRACT statement to source the records rejected by the "-silent" option
It would be very useful to allow the EXTRACT statement source rejected records in some way. For instance, when records are rejected by using the "-silent" option in DefaultTextExtractor, it would be useful to shunt those records to a rejected output file. "WITH REJECTED RECORDS AS @mybadrecordrowset" (or similar) as an option on the EXTRACT statement would be pretty awesome to have.
Thanks for the suggestion. We are considering at some time to provide an “exception” rowset that could capture such information. Right now we have no ETA and will keep collecting feedback.
Monica Huerta commented
Hi, is there any update on this?
When we are using the silent:true option, it would be really helpful to log the rows skipped due to invalid number of columns.
Any update on this? For those of us using dynamic schemas in ADFv2 this would be huge!