Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Data Migration From DB2
 
From:   Mani, Vijay

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016