Using IBM InfoSphere Warehouse Design Studio with pureXML data, Part 1, Create an ETL data flow to populate a hybrid data warehouse

From the developerWorks archives

Cynthia Saracco

Date archived: January 12, 2017 | First published: March 25, 2010

Learn how to integrate business-critical XML data into your data warehouse using IBM® InfoSphere™ Warehouse Design Studio and DB2® 9.7 pureXML®. This two-part article series provides step-by-step instructions for using pureXML as both a source and target data source for extract, transform, and load (ETL) operations developed with InfoSphere Warehouse Design Studio. This article explains how to build a single data flow that uses an XML-based source table to populate two target data warehouse tables. One of these tables contains only relational data, while the other contains both relational and XML data.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, Big data and analytics, XML
ArticleID=477318
ArticleTitle=Using IBM InfoSphere Warehouse Design Studio with pureXML data, Part 1: Create an ETL data flow to populate a hybrid data warehouse
publish-date=03252010