Archives of the TeradataForum

Message Posted: Tue, 18 Sep 2012 @ 23:02:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

We are migrating the data from DB2 to Teradata. The data and the number of table is huge, we have around 2000 tables to be forklifted from DB2.

As a initial phase we are doing a history migration from DB2 to Teradata.

Once the history data is migrated we are loading the loadready file in Teradata . Now the issue is we need to compare the data that is present into DB2 and teradata for the data quality, since the number of tables and data is huge , its difficult to compare field by field between Db2 and teradata.

Can you please suggest the possible ways of Validating/comparing the data in db2 and teradata which will simplify my process.

Thanks,

Vijay Mani

	<Prev	Next>		<<First	<Prev	Next>	Last>>