Sometimes the Oracle Database installation has caused some hiccups that wouldn't necessarily have been caused if we had used SQL Server." "One big improvement we would like to see would be the workflow integration of codeset mapping with the erwin source to target mapping. "We chose to implement on an Oracle Database because we also had the erwin Data Modeler and Web Portal products in-house, which have been set up on Oracle Databases for many years. More erwin Data Intelligence (DI) for Data Governance Pros → And, of course, you have the governance of the mapping to make sure that source-to-target mapping is done and is being shared across the company." You have the governance of the business data models and how those business data models are driving the physical implementation of the actual databases.
INSIGHT ERWIN DATA MODELER VS CODE
You have the governance of the code sets versus the governance of the business terms and the definitions of those business terms. And the governance can be done at multiple levels. They then feed into the automation of the source data extraction, like the source data mapping of the source data extraction, the code development, forward engineering using the ODI connector for the forward automation." "The data management is, obviously, key in understanding where the data is and what the data is. Those value pair mappings come in quite handy and are utilized quite extensively. "We always know where our data is, and anybody can look that up, whether they're a business person who doesn't know anything about Informatica, or a developer who knows everything about creating data movement jobs in Informatica, but who does not understand the business terminology or the data that is being used in the tool." "Overall, DI's data cataloging, data literacy, and automation have helped our decision-makers because when a source wants to change something, we immediately know what the impact is going to be downstream." "erwin has tremendous capabilities to map right from the business technologies to the endpoint, such as physical entities and physical attributes, from a lineage standpoint." "We use the codeset mapping quite a bit to match value pairs to use within the conversion as well.
0 kommentar(er)
