need a suggestion i have around 250 insert query and 50 databse checkpoint so shall i read the insert query from excel or sqlfile? datadriven approach or shall i save the query 20 per each variable in projrct global variables? which would be recommended as per the performance and playback time
What's different about the insert queries? Why 250? Are they so different that you need to actually have 250 queries written out verbatim? Could you create a code routine that would have a template of an insert query that you would just replace values in that you can call? That way anything you would have in a data driven structure would be more efficient: just values rather than whole SQL statements.
Likewise for the database checkpoints, you can probably be more efficient to, again, write custom code to do the datatbase checkpoint rather than having to maintain 50 different ones. Using, the same data source as generating the inserts, you could have code that does the proper comparisons of the data tables.
Why automate? I do automated testing because there's only so much a human being can do and remain healthy. Sleep is a requirement. So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group. I love good food, good books, good friends, and good fun.