MDM Beta: Allowing to select both Excluded and Map column in Mapping tab

Hi Ravikumar,

The approach we are taking for #2 for the considerable future is to leverage refinery, DataStage aaS or other ETL tools to combine the data before loading into MDM.

Thank You

Hi Ravikumar,

Thank you for your reply.

1. The goal of the mapping to is map (or not map) a column in dataset to an attribute in the MDM data model. So for each column, you should have both options available, correct? One option is to exclude from mapping, i.e. not map it and the other option is to select an attribute in the data model, i.e. map it.

2. Currently, you would need to use refinery services or other ETL tools to combine the data into 1 file first before performing mapping and matching. But this is a great requirement we would consider for future.

Thanks

Here, I have mentioned one possible defect(#1) and second one as an Idea.

1. In Mapping tab for the dataset columns, it was allowing me to select "Exclude from mapping" and also allowing me to select the column to be mapped. I think this not correct.

2. Currently I can do the mapping and loading from Single file. But we might have data in different files and there should be way to add data from multiple files (data sets - Address file and Phone file) to single entity(Person) before I go for matching set up.

Thank you for the Idea, Ravikumar. I think we have two separate requests here, can you confirm or are these items related?

For both of them could you add a little detail here as to what you are trying to accomplish with these requests as I'm not quite following the objective.

If I understand #2 correctly, you are asking to match multiple source files with the same entity. This is in fact possible. But again more clarity on what you're trying to accomplish would help us better understand the requirement.