Comparison to PD to Teradata Tables
We are migrating data models, logical and physical from ERwin to PowerDesigner and looking for the best approach. Our thoughts are
1. Use ERwin to migrate to PD.
2. Perform a "Complete Compare" between newly created PD Physical table and the current Teradata Table to validate the content of the columns. Our ERwin DM may not be current view of the physical tables due to bad processes where developer add columns and Data architecture team was not in the loop of the development process.