【正文】
江蘇省電力公司信息化登高項目 MDM 培訓手冊第 33 頁 共 85 頁Repository 屬性設(shè)置是設(shè)置 Repository 的多語言以及運行端口,每個Repository 需要設(shè)置不同的 port,如果設(shè)置相同則會導致 Repository 無法加載。主表之間可以共享數(shù)據(jù),比如供應商和客戶可以共享國家這個表。 and other display options). This table is available only in Family mode. Data Groups A single hierarchy table named Data Groups. Stores the hierarchy of data groups used to break the entire set of objects in the MDM repository into manageable subgroups. 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 37 頁 共 85 頁Relationships A single table named Relationships. Used to define relationships between records in your tables. MDM 字段類型可參考如下:Field Data Types (Standard SQL)Field Data Types (Standard SQL) Data Type MV SQL Server Oracle DB2 MaxDB Description Text Nvarchar Nvarchar2 Varchar Varchar Text field (= 333 chars). Text Large Text CLOB CLOB Long Unicode Text field ( 333 chars). Integer Int Number Int Fixed (10) 4byte integer field. Real Real Number Float Float (16) 4byte real field. Real8 Real Number Float Float (38) 8byte real field. TimeStamp DateTime Date Timestamp Timestamp DateTime field. Boolean Bit Number Smallint Fixed (1) Twovalued field. Field Data Types (MDM Extended)Field Data Type MV Description Text Normalized Text field with “special” (nonalphanumeric) characters removed for searching/sorting (always displays original). Name Text field with internal structure for storing parts of a name (prefix, first, middle, last, suffix).Log Text Large field with internal structure for managing multiple timestamped blocks of text within a single field.AutoID Integer field that MDM automatically increments. Currency Real8 field displayed with a currency symbol. GM Time TimeStamp field that is adjusted to a particular time zone. Measurement ● Real field with an associated unit of measure. Literal Date TimeStamp field that ignores the time part. 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 38 頁 共 85 頁Literal Time TimeStamp field that ignores the date part. Create Stamp TimeStamp field that MDM automatically sets with the date/time of record creation. Time Stamp TimeStamp field that MDM automatically updates with the date/time of modification when any of the fields being tracked are updated. User Stamp Text field that MDM automatically updates with name of user who makes the change when any of the fields being tracked are updated. Mask ● Virtual field that stores an enumeration of main table records. It is never displayed but is used for searching. Lookup [Flat] ● Field whose value(s) are a lookup into a flat table. Lookup [Hierarchy] ● Field whose value(s) are a lookup into a hierarchy table. Lookup [Taxonomy] Field whose single value is a lookup into a taxonomy table.Lookup [Qualified] ● Field whose values are a lookup into a qualified table. Lookup [Image] ● Field whose value(s) lookup into the Images table. Lookup [Text Block] ● Field whose value(s) lookup into the Text Blocks table. Lookup [Copy Block] ● Field whose value(s) lookup into the Copy Blocks table. Lookup [Text HTML] ● Field whose value(s) lookup into the Text HTMLs table. Lookup [PDF] ● Field whose value(s) lookup into the PDFs table. Lookup [Sound] ● Field whose value(s) lookup into the Sounds table. Lookup [Video] ● Field whose value(s) lookup into the Videos table. Lookup [Binary Object] ● Field whose value(s) lookup into the Binary Objects table. Attribute Data TypesAttribute Data Type MV Corresponding MDM Field Type Text ● Lookup [Flat] Numeric ● Measurement Coupled Numeric ● n/a Table 操作創(chuàng)建 Table: Repository 在 Console 上點擊 或者在 Table 視圖中鼠標右鍵然后選中 Add Table,如圖所示: 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 39 頁 共 85 頁 2. 在 Table Detail 中填入表名及表名代碼 3. 選擇表類型 : 4. 其它屬性設(shè)置 . Display Fields: 設(shè)置顯示字段 Unique Fields: 設(shè)置表的主鍵 Key Mapping: 設(shè)置表是否需要進行 Key Mapping. Hide Table: 設(shè)置表是否為隱藏表. 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 40 頁 共 85 頁 刪除表:選中 Repository,在 Table 視圖中刪除表。多語言設(shè)置: 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 45 頁 共 85 頁4. Data ManagerData Manager 是數(shù)據(jù)進行管理的工具,主要功能如下:? 數(shù)據(jù)查詢與維護? 數(shù)據(jù)管理工作流? 數(shù)據(jù)清洗和合并Data Manager 連接到 Repository:選擇 MDM 服務(wù)器、 Repository 和登錄的語言,輸入用戶名和密碼。查看 Family Table 使用 Family Mode.如果 Repository 中沒有定義 Family Table,則無法切換至 Family Mode。數(shù)據(jù)比較功能操作:選中需要比較的數(shù)據(jù)記錄鼠標右鍵,點擊 。可調(diào)用: 設(shè)置校驗表達式是否可以被其他校驗表達式調(diào)用。工作流圖標示意圖: 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 56 頁 共 85 頁MDM Workflow 是基于微軟 Visio 畫圖軟件進行流程定義。t charge you more than 35% of your pensation if you win the case.If you a。t agree with the disciplinary action your employer has taken against you? your employer dismisses you and you think that you have been dismissed unfairly.For more informu, take advice from one of the anisations listed under Further help.Employment tribunals are less formal than some other courts, but it is still a legal process and you will need to give evidence under an oath or affirmation. Most people find making a claim to an employment tribunal challenging. If you are thinking about making a claim to an employment tribunal, you should get help straight away from one of the anisations listed under Further help. ation about dismissal and unfair dismissal, see Dismissal.You can make a claim to an employment tribunal, even if you haven39。也就是 Workflow 是不能跨多個 Table 執(zhí)行的。下面分別介紹:數(shù)據(jù)驗證功能操作如下:,然后切換到 Validations 界面 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 52 頁 共 85 頁相關(guān)設(shè)置如下:校驗:此處用于定義校驗表達式錯誤消息: 定義校驗出錯后的錯誤消息。 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 48 頁 共 85 頁如果要進行數(shù)據(jù)匹配使用 Match Mode.Data Manager 搜索數(shù)據(jù)步驟如下 : Table: 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 49 頁 共 85 頁Data Manager 維護步驟如下:在工具欄中選中新增數(shù)據(jù)按鈕或者在 Record 區(qū)域鼠標右鍵新增選中要刪除的數(shù)據(jù)或者按住 Ctrl 后鼠標選擇要刪除的多條數(shù)據(jù),然后在工具欄中點擊刪除按鈕或者在 Record 區(qū)域鼠標右鍵刪除 江蘇省電力公司信息化登高項目 MDM 培訓手冊第 50 頁 共 85 頁選中要修改的數(shù)據(jù)然后再 Record Detail 中進行修改。查看 Main Tabal 和 Flat Ta