How to find source-to-target table relationship by OPB_* table? 1

[roopalidoshi]

Do you have an query OR relationship among repository OPB_* tables, which can provide information on "Source Table Name-Mapping Name-Target Table Name' from Power Center v6.1 repository?

The Metadata reporter gives information session by session but I want to view directly like excel sheet style that What are my source tables and their corresponding mappings and Target table OR for a particular source column what is corresponding target column.

I would appreciate if you can provide some document/info on this. I understand that v7.1 repository might have changed drastically, so I dont want to spend much time on doing reverse engineering of v6.1 repository from ERWIN for knowing table relationships.

Thanks,
Roopali

 

[blom0344]

The information is there in two special views in the repository:

REP_TARG_MAPPING
REP_SRC_MAPPING

Now every mapping can have both multiple sources / multiple targets, so a join over the fields SUBJECT_AREA / MAPPING_NAME will produce correct result for mappings that have 1 source and one target.
In other cases you can modify the SQL:

Select DISTINCT SOURCE_NAME,TARGET_NAME,A.MAPPING_NAME from REPO51.REP_SRC_MAPPING A,REPO51.REP_TARG_MAPPING B
WHERE A.MAPPING_NAME = B.MAPPING_NAME

Ties Blom
Information analyst
tbl@shimano-eu.com

 

[roopalidoshi]

Hi Ties Blom,

Thanks a lot for your valuable reply. I looked the views suggested by you.

Is there a way that this repository will not show all the mappings from a particular repository? I am looking my TEST repository but I can not find all the mappings from a particular folder.

Thanks,
Roopali

 

[blom0344]

Just a shot in the dark....

Did you use shortcuts between folders?

Ties Blom
Information analyst
tbl@shimano-eu.com