Archives of the TeradataForum
Message Posted: Tue, 18 Sep 2012 @ 23:02:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|