11. A data validation computing device, comprising a processor and a memory coupled to the processor which is configured to execute one or more programmed instructions comprising and stored in the memory to: receive a data transformation specification from a user; analyze the data transformation specification to determine data transformation rules, wherein the data transformation rules are indicative of a relationship between corresponding fields of a source repository and a target repository; generate test cases and test scripts based on the data transformation rules; determine a number of records on which the test cases and the test scripts are to be executed; execute the test cases and the test scripts in an order based on the data transformation rules, on the source repository and the target repository to validate the relationship between the corresponding fields of the source repository and the target repository, wherein execution of the test cases and the test scripts is initiated serially when the determined number of records is less than a critical threshold, and wherein the execution of the test cases and the test scripts is initiated in parallel when the determined number of records is more than a critical threshold; and generate a log file indicative of the outcome of the execution of the test cases and the test scripts.
11. A data validation computing device, comprising a processor and a memory coupled to the processor which is configured to execute one or more programmed instructions comprising and stored in the memory to: receive a data transformation specification from a user; analyze the data transformation specification to determine data transformation rules, wherein the data transformation rules are indicative of a relationship between corresponding fields of a source repository and a target repository; generate test cases and test scripts based on the data transformation rules; determine a number of records on which the test cases and the test scripts are to be executed; execute the test cases and the test scripts in an order based on the data transformation rules, on the source repository and the target repository to validate the relationship between the corresponding fields of the source repository and the target repository, wherein execution of the test cases and the test scripts is initiated serially when the determined number of records is less than a critical threshold, and wherein the execution of the test cases and the test scripts is initiated in parallel when the determined number of records is more than a critical threshold; and generate a log file indicative of the outcome of the execution of the test cases and the test scripts. 14. The device as set forth in claim 11 , wherein the processor coupled to the memory is further configured to execute at least one additional programmed instruction comprising and stored in the memory to ascertain at least one of inconsistent standards between corresponding fields of the source repository and the target repository, discrepancies in data format between the corresponding fields of the source repository and the target repository, difference in structure of data between the corresponding fields of the source repository and the target repository, missing values between the corresponding fields of the source repository and the target repository, data fields filled with default values or nulls in the corresponding fields of the source repository and the target repository, or data anomalies.