SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DI Studio - Data Validation error records

Reply
Occasional Contributor Roc
Occasional Contributor
Posts: 16

DI Studio - Data Validation error records

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.

Occasional Contributor Roc
Occasional Contributor
Posts: 16

Re: DI Studio - Data Validation error records

Wow I just realized the version this company is using is from 2009 4.2. So I really don't expect anyone to be able to answer.

Respected Advisor
Posts: 4,173

Re: DI Studio - Data Validation error records

@Roc

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.

Super User
Posts: 5,424

Re: DI Studio - Data Validation error records

I'm pretty sure that the error table will be created for you, if possible (libref assigned, user has the necessary rights). The code generated will give you the final answer.

This is the forum for DI Studio (and other products within the data management scope ).
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 334 views
  • 0 likes
  • 3 in conversation