In my present project I m testing on reports which needs to be checked everyday manually by executing SQL queries for all columns from source tables, Dims and Facts tables and destination tables. Is it possible to do this Automate....?? Please help me
When I first started out in Technical Operations I would run SQL scripts to verify the ETL processes we had running. Now that I had experience in SQA I would more likely write some unit tests so its easy to tell what failed using the reporting tools or the test runner(s).
You could create unit tests in SQL Server.
You could also create unit tests in Visual Studio using a SQL connection string.