12-29-2015 10:19 AM
1. If you have not used this transformation in DI studio you will not know the answer.
2. The question? Does Data Validation generate an error table or does one(error table) have to be created first. Under options it asks for libname.Tablename to send errors but it does not say if it will create a table or you must create a table.
Also we need a community for DI STudio.
12-29-2015 08:02 PM
Based on newer DIS versions but from memory it's the same for DIS4.2:
You can under one of the tabs choose if an Error and/or Exception table should get created. You then have a list of standard columns but you can modify this selection.
I believe the default location for the Error and Exception tables are WORK and you then might also want to register the tables and point them to a permanent location.
So yes, SAS/DIS does it for you but you must tell DIS how it should be doing it.
12-29-2015 04:31 PM