By following the steps outlined in this tutorial, you have learned how to get an initial meaningful logical data model for campaign analysis business requirements using InfoSphere Data Architect. You have also learned how you can reuse the dependencies and relationships that are predefined for you in the Banking Data Warehouse industry model. Now that you have created a meaningful logical data model, you can use InfoSphere Data Architect to easily create a physical model from the logical data model for your target database platform. From this physical model in InfoSphere Data Architect, you can run the DDL to deploy the model into your target system. This gives you a good starting point for your overall DWH architecture. Also, the known dependencies and relationships between Core Warehouse and Data Mart models can be used in a next step for the definition of transformation rules for the data population process (ETL). When you use the InfoSphere Integration Server for ETL, this process can be automated.
- Dr. Gregor Meyer, Senior IT Architect from Böblingen Lab (Germany)
- Neil Ryan, IT Architect and Developer from Industry Models and Assets Lab in Dublin (Ireland)
- Paul Kilroy, IT Architect from Industry Models and Assets Lab in Dublin (Ireland)