Use the following Metadata Exchange (MX) Views:
REP_TARG_TBLS provides a list of targets in the repository
REP_TARG_TBL_COLS provides the properties of columns defined for the target tables in a data warehouse or data mart
It contains a column COLUMN_KEYTYPE that takes of the following values: Primary Key, Not a Key, Foreign Key, Primary and Foreign Key.