22 Mar 2012 — Show descriptions | Hide descriptions

• Dimensional modeling with InfoSphere Data Architect, Part 2: Reverse engineering

  Follow the workflow outlined in part two of this series to learn how to update existing data models and minimize the impact on the production environment by reverse engineering from an existing data source.

• Update: Creating scripts more efficiently in the SQL and XQuery editor

  Get on board with new enhancements to the SQL and XQuery editor, a feature of Data Studio, InfoSphere Data Architect, and InfoSphere Optim Query Tuner.

• Bitemporal modeling with InfoSphere Data Architect, Part 2: Modeling system period temporal requirement

  In Part 2 of this series, learn how to model bitemporal properties within tables by modifying the physical data model that was created in Part 1, or reverse-engineering a database to create and then modify a new model using InfoSphere Data Architect 7.6.

• Bitemporal modeling with InfoSphere Data Architect, Part 1: Modeling application period temporal requirement

  Create a temporal logical data model, transform it into a physical model for DB2 for z/OS version 10, and then generate DDL with temporal-specific syntax that you can run on a database server.

• Dimensional modeling with IBM InfoSphere Data Architect, Part 1

  Use this collaborative data design solution to discover, model, relate, and standardize diverse and distributed data assets. Part 1 focuses on using forward engineering to achieve a multidimensional data model.

• Integrating Rational Software Architect with InfoSphere Data Architect

  Make your application model and data model work together using this article, which is updated for the InfoSphere Data Architect product (formerly the Rational Data Architect product).

• Develop mapping models with IBM InfoSphere Data Architect

  Find out how to develop a complete source-to-target mapping model for your data warehouse project that is easy to modify, capable of version control, easily reported, and easily exported to other formats.

• Demo: Efficient multidimensional data modeling with InfoSphere Data Architect

  See how a data architect at a fictional company uses InfoSphere Data Architect to efficiently create data models of a new data mart that can be used for business intelligence and analytical reports.

• Communicate changing requirements to integration developers with IBM InfoSphere FastTrack

  Learn how to use IBM InfoSphere FastTrack with a downloadable sample to import metadata, create and update a mapping specification, and generate a DataStage job to help you better manage your changing data sources and business requirements.