My source data is in Oracle and target data is in Teradata.Can you please provide me the easy and quick way to validate data .There are 500 tables
I guess you can use TPT . In TPT, temporarily load data from oracle to teradata and with in same script, compare the temp table and corresponding teradata table, export results into an output file and drop the temptable which was loaded with oracle data.
You can pass the table name as parameters throug unix shell script and rotate the loop till end of the paramters in the while loop of shell.
My SOurce Data is in oracle and Target is in Teradata.Can you please provide me easy and quick way to validate Records between oracle and Teradata.There are 500 Tables.