ODBC query to return all migrated Columns (FKs) with a different data type than their parent colu (4351957)

Description: 

ODBC query to return all migrated physical attributes with a different data type than their parent

Solution:

Here is the ODBC Query which should give you the aforementioned report.

SELECT
 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'
FROM
EM0.MV_PHYSICAL_ATTRIBUTE@ PA
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@
WHERE
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.