12-22-2015 03:49 PM
SAS D.I Data Validation is supposed to remove dups to an error table. It looks as if it have removed the duplicate records but when I open the table I set up to hold the duplicate records it errors and then shows no records. Does anyone have any knowledge of veiwing the duplicate records. I need the duplicates to try to understand why the join is createing them in the first place.
Thanks
12-22-2015 09:18 PM
The good news is: It works if you set-up things correctly.
The bad news is: It's almost impossible for us to give you advice with the information you've provided.
What you could do:
1. Explain in detail what you're doing, what works and where things fall over
2. State which DIS version and OS you're using
3. Send a screenshot of the flow and eventually also attach the .spk of the job with dependent objects like library and table metadata
4. Attach the DIS generated code; at least the bit from the Validation Transformation