ODBC query to return all migrated physical attributes with a different data type than their parent
Here is the ODBC Query which should give you the aforementioned report.
PE.NAME || '.' || PA.NAME AS 'PARENT NAME',
PA.PHYSICAL_DATA_TYPE AS 'PARENT DATA TYPE',
CE.NAME || '.' || CA.NAME AS 'CHILD NAME',
CA.PHYSICAL_DATA_TYPE AS 'CHILD DATA TYPE',
R.NAME AS 'MIGRATING RELATIONSHIP'
INNER JOIN M0.ENTITY PE
ON PA.OWNER@ = PE.ID@
INNER JOIN EM0.MV_PHYSICAL_ATTRIBUTE@ CA
ON CA.PARENT_ATTRIBUTE_REF = PA.ID@
INNER JOIN M0.ENTITY CE
ON CA.OWNER@ = CE.ID@
INNER JOIN M0.RELATIONSHIP R
ON CA.PARENT_RELATIONSHIP_REF = R.ID@
PA.PHYSICAL_DATA_TYPE <> CA.PHYSICAL_DATA_TYPE ;
Note: You can also refer to sample queries in the Query sub-folder under the folder where erwin DM is installed at. Additionally, there are also quite a few sample queries bundled in the application for Report Designer. You can access them by launching Report Designer, under File | Open Pinned Reports. Once in the pinned reports, you can pick Model Reports from the drop down to see a lot of useful reports.