Advanced topics for DWE users Part 2, Best practices for choosing DB2 Data Warehouse Edition SQL Warehousing variable phases
From the developerWorks archives
Date archived: January 11, 2017 | First published: February 01, 2007
IBM® DB2® Data Warehouse Edition SQL Warehousing Tool provides variables and variable groups to enable you to customize your data transformations and work flows. Optimize your DB2 Data Warehouse Edition flow design with a good understanding of variable usage in order to promote user satisfaction, support flow reuse, and help reduce administration overhead. In this article, find recommendations and best practices on how to best utilize different variable phases to maximize the benefits of variable usage in SQL Warehousing Tool data flows and control flows during design time, and how each variable phase can impact the runtime behavior when these flows are executed.
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.