Let's say I have a two tables called TAB01 and TAB02, both have the column name COLID but COLID means something different in the two tables.
COLID in TAB01 description : This is a system generated sequential number.
COLID in TAB02 description : This field is the external number loaded from system x.
I want to capture the above in the Analyst Tool business glossary.
What is the best way to do this?
The way I see it:
1) Capture a term called COLID, add synonyms in the synonyms block for TAB01 and TAB02
(This options only allows me to capture a description/context information unfortunately.)
2) Capture terms TAB01 and TAB02, add categories "Tables". Capture COLID(Category "Fields") and add TAB01 and TAB02 as related terms
Capture a synonym for COLID
(This option allows that I can capture more information for TAB01 and TAB02 but does not solve the duplicate name issue.
Also, only Context can be captured for the synonym)
Any other options?
Retrieving data ...