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

Data validation transformation

Occasional Contributor
Posts: 19

Data validation transformation

[ Edited ]

Difference between Error table and Exception table of Data_Validation_Transformation?         version 4.2 di studio...

can you give example?

Super User
Posts: 5,853

Re: Data validation transformation

Posted in reply to katkarparam
This transformation have been given a face lift in later releases, so I urge you to upgrade (either way)!
If you look in the generated code you'll see the the table layouts, and even see the logic if you look to dig.
The documentation here is quite scarce, but on short the error table contains the records that doesn't copy with the validation criteria (optional by defonition) and validation table tells you what actually went wrong. Its not uncommon you wish to joins those to get the full picture. Again, simpler and better in later releases.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation