Questions tagged [master-data-management]

Master Data Management (MDM) aims to provide a single point of reference for an organisation's slow-moving but critical data. MDM does not give precedence to fast-moving / transaction data.

A master data management tool can be used to support master data management by removing duplicates, standardizing data (mass maintaining), and incorporating rules to eliminate incorrect data from entering the system in order to create an authoritative source of master data.

Here is the Wikipedia article for MDM.

External Resources

64 questions
2
votes
1 answer

Why use lookup tables in a database

This is a theoretical question which I ask due to a request that has come my way recently. I own the support of a master operational data store which maintains a set of data tables (with the master data), along with a set of lookup tables (which…
1
vote
1 answer

Oracle Hyperion MDM Web Service API and .NET interop

We have Oracle Hyperion Master Data Management (aka Data Relationship Management) installed along with it's Web Service API, which is essentially an EAR file deployed on WebLogic. A built-in server side security policy has been attached to this web…
Ranga
  • 618
  • 1
  • 8
  • 14
1
vote
1 answer

Efficient way to integrate Informatica MDM DaaS email validation utility as Cleanse function

We have DaaS email validation utility subscription provided from Informatica which we have added as Cleanse function in MDM HUB. we are trying to bypass the DaaS utility validation if email from source is coming as blank or null. just to avoid…
swapnil
  • 11
  • 2
1
vote
1 answer

SAP MDG see Change Documents of a given Business Partner?

I would like to know if there's a way or some query to see the Change Documents out of a given Business Partner using SAP or SAP Webdynpro GUI. I've googled but tables such as CDHDR or CDPOS are not working for me. Any other thoughts?
Dexter
  • 25
  • 7
1
vote
2 answers

Filter one dataframe based on the last two digits of another dataframe's value under one column in R

The table, Data_frame, has an ID column that contains over 1000 participants' information, such as "Sample_LI.01" My_ColData also has an ID column that contains only 40 participants' different information, such as "Sample_LI-01". I want to use the…
1
vote
1 answer

create a changeset during staging ETL to Microsoft MDS for approval

In MDS, if i manually make changes, I can create a changeset for approval. Is there a way to force approvals for changes that come in via the staging tables? if so, How? thanks
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
1 answer

Maintain Cross reference in SAP-MDG

I am new to SAP Master Data Governance and I am trying to identify how can we store cross reference details in MDG. I got to know about key mapping but that is not something that I understand. My requirement is: I have 10 applications sending data…
Divyesh Kalbhor
  • 385
  • 3
  • 19
1
vote
0 answers

VBA Code for Index Match on Customer Data Sheet - Data Enrichment

First time poster beginner/intermediate vba coder. I've used userforms and input boxes in the past to build financial models but nothing like what I'm trying to do now. Situation: I have a large Master Data File ~25mb excel file that uses an AFO to…
JtPaint005
  • 11
  • 1
1
vote
1 answer

How to use REGEX patterns to return day of the week if a date is entered?

I am trying to create something that will populate the day of the week in one cell based on a date entered in another, BUT in Master Data Services. I know I will need to do this in a business rule and apply it to the attributes. I am wondering if…
nation161r
  • 51
  • 1
  • 3
  • 14
1
vote
1 answer

TIBCO MDM 9 : log4j:WARN No appenders could be found for logger (RulebaseCustomFunction)

Getting below error while I am trying to print MqLog to elink.log via RulebaseCustomFunction (MDM 9)\ ERROR [stderr] (TIBCO EMS Session Dispatcher (895)) log4j:WARN No appenders could be found for logger (RulebaseCustomFunction). ERROR [stderr]…
MRAgrawal
  • 123
  • 1
  • 10
1
vote
1 answer

What is the main difference between MDM and ESB?

I have read a few articles online, but I'm still pretty confused. What is the main difference between ESB - mediator and MDM? Is MDM (Master Data Management) just a subset of ESB (Enterprise Service Bus)? Is the ESB just the underlying technology…
user2670818
  • 719
  • 5
  • 12
  • 28
1
vote
2 answers

Master Data Management using Graph Database

I am building a master database to store all relevant information about our customers. I am using Neo4j. Below is a sample of our model. We have Person, that can be registered in 3 of our mobile applications. (App.01, App. 02, App. 03 - We use CPF…
p.magalhaes
  • 7,595
  • 10
  • 53
  • 108
1
vote
0 answers

when to instantiate masterdata?

when should I instantiate my masterdata ( represents the business objects which are agreed on and shared across the enterprise) classes? I have following project layers: web interface web api wcf service businessLogic data access layer Should I…
AJ_83
  • 289
  • 1
  • 8
  • 22
1
vote
1 answer

How to store low cardinality master data in database

In my app database there are certain columns which can have only 2-4 possible values. For example "GENDER" can have only 2 values('Male', 'Female') "MARITAL STATUS" can have 3 values('Single', 'Married', 'Divorced') "PROC_STATUS" can have 3 values…
1
vote
1 answer

IBM MDM Server BatchProcessor Exception_CustomerReflectionDelegate_JNDINameLookup Error

I am trying to run IBM MDM Server BatchProcessor ; on executing rubBatch.sh script I am getting following error: ERROR - [Exception_CustomerReflectionDelegate_JNDINameLookup:] CDKBC2030E:Unable to locate a reference using the following…