Skip to Main Content
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
book

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

by Whei-Jen Chen, Pat Bates, Timothy Donovan, Garrett Fitzsimons, Jon Lind, Rogerio Silva
October 2012
Beginner to intermediate content levelBeginner to intermediate
506 pages
12h 43m
English
IBM Redbooks
Content preview from Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Chapter 4. Data modeling: End to end 107
process for performing this action is to create a new physical data model, which
in turn can be utilized to create a DDL file that can be used to build the new
database.
Perform these steps to create the DDL file that represents the dimensional
logical model:
1. From within InfoSphere Data Architect, select and right-click our dimensional
logical model IND_CST_DYN_FACT.ldm to bring up the option menu. Select
Transform to Physical Data Model.
In the wizard, make sure the Create new model option is selected, then click
Next.
2. In the next panel, specify the version of DB2 or other relational database, that
will host this database structure. In our example, we use DB2 10.1. Click
Next.
3. In the final ...
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.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 0738437255Purchase book