learndmdwbi

Erwin Tutorial

All Fusion Erwin Data Modeler: All Fusion Erwin Data Modeler commonly known as Erwin, is a powerful and leading data modeling tool from Computer Associates. Computer Associates delivers several software for enterprise management, storage management solutions, security solutions, application life cycle management, data management and business intelligence. Parallax Capital Partners acquired Erwin and incorporated Erwin…

Read More

Data Modeling Tools

There are a number of data modeling tools to transform business requirements into logical data model, and logical data model to physical data model. From physical data model, these tools can be instructed to generate sql code for creating database. Popular Data Modeling Tools: Tool Name Company Name Erwin Computer Associates Embarcadero Embarcadero Technologies Rational…

Read More

Data Warehouse and Data Mart

A Data Warehouse is a relational/multidimensional database that is designed for query and analysis rather than transaction processing. A data warehouse usually contains historical  data that is derived from transaction data. It separates analysis workload from transaction workload and enables a  business to consolidate data from several sources. In addition to a relational/multidimensional database, a…

Read More