how to validate in SAS 9.4 especially Data Integration Studio transformations

[touwen_k]

I am searching if there is some existing test to validate if most used DI transformations work properly after installing hotfixes? Also what else is handy validate in SAS 9.4, pls advise.

[LinusH]

AFAIK there is no such test available OOTB.

When it comes to DI Studio jobs/tranformaitons - this is a development tool. 

You update transformations and jobs after there is a requirement to do so, and then you test your updated jobs before deploying them to production.

What you could do is copy all deployed jobs code . Redeploy all jobs and then do a bulk text comparison using your tool of choice.

[touwen_k]

Thank you for your answer. It is not always clear in which group the topics suits the best.

Could you tell some more about the tool of my choice, what can be the best to do such comparison?

[touwen_k]

I am searching for guidance or an existing test to validate that most common transformations in Data Integration Studio of SAS 9.4 work properly after installing hotfixes? Pls advise.

[LinusH]

Merged due to duplicate post.

[Quentin · Accepted solution]

I don't know about DI studio, but for SAS 9.4 in general it ships with an Install Qualification tool and an Operational Qualification tool.  I know that's the case for the PC version of 9.4, I assume it's also the case with 9.4 running on a server (I'm not an admin).