Figure 9-86 The Beverage Company star schema imported into DB2 Cube Views
Congratulations, you have imported into DB2 Cube Views a star schema
designed in DB2 Warehouse Manager!
9.5.7 Metadata integration of DB2 Cube Views with Informatica
Informatica is one of the leading ETL tool vendors with tools such as PowerMart
and PowerCenter that you can use to populate a DB2 data warehouse. The
complex flow of data and transformations can be designed using PowerMart
Designer. You can use Informatica PowerMart Designer to import and export of
metadata via an XML file format.
This scenario demonstrates how to transform the met ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.