Master Data Tables are those data tables that are the core focus of a entitiy’s Master Data Management Strategy. Master Data Tables are labelled as such and are the opposite of Transactional Data Tables. And where Transactional tables contain content that describes the characteristics of events and transactions, Master Data Tables describe the characteristics of parties to the transactions. Where Transactional Tables tend to have a large number of records, Master Data Tables tend to have far fewer records. This makes sense as one employee will earn multiple paychecks, one vendor will sell us multiple goods and a single customer may make multiple purchases from us.

In most enterprises, there are five key Master Tables as represented in the image below.

In each of these Master Tables, there is a key field which is the unique identifier of the party that is the object/subject/focus of all of the other content in that table. In each of the five stacks – or data families in the image above – we also see samples of children, grand-children and great-grand-children of the parents of the family.

Revision: 5
Last modified: 2019/03/31

Zpětná vazba

Bylo to užitečné ?

Ano Ne
Označili jste toto téma za neužitečné...
Mohli byste nám, prosím, říct, proč ? Děkujeme !
Děkujeme za vaši zpětnou vazbu.

Sdělte nám váš názor na toto téma.

Prosím, nepoužívejte toto pro otázky k podpoře.
Pro zákaznickou podporu, nás kontaktujte zde.

Zveřejnit komentář.