Kalido MDM introduced the functionality of ODBC loaders in their new release of their MDM product. Now the data can be loaded from the staging tables itself, which makes Kalido MDM a complete MDM tool.
But when we create the staging tables in MDM, and save the staging tables, we are stuck with it. We cannot go back and change the column names in the tables or do any modification in the staging tables. The only way to edit the staging tables is to drop the staging tables and re-create it from the scratch which is a process in most of the cases.
A better way to change the column names in the staging tables for MDM, is to export the whole model into an XML(which is done using MDM tool itself) and then modify that XML file and change the column names as required. Once editing the XML file is done, we can import the file back into the MDM tool and it would have the new column names and also it would contain any structural changes we have made to the MDM model.
The only disadvantage for this process would be: it requires the knowledge of XML file, which the MDM model would be exported.
Remember: Always take a back Up of the original XML file...
This is one of the way we can change the column names in MDM staging tables.
A question: may be not related to your post but -
ReplyDeletewhat is the difference between a landing table and staging table?
Landing Tables are the copy of the Operational Systems...or you can say copy of the source systems
ReplyDeleteStaging Area is the area before the data is loaded into the warehouse. So all the transformations, conversions could be done between Landing to Staging area. Once the staging area is populated..the next step is to load the warehouse..