The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

System Administration Certification exam 919 for Informix 11.70 prep, Part 7: Informix Data Warehousing

Archiving Informix database

Manjula Panthagani (manjulap@us.ibm.com), Advisory Software Engineer, IBM

Manjula Panthagani is a member of the Down System and Diagnostics Team for IBM Informix Technical Support, a team responsible for handling critical customer situations. Manjula has been working in this role for more than 10 years. She is IBM Certified System Administrator for Informix. She is one of the Redbooks authors of Data Warehousing with Informix server.

Sanjit Chakraborty (sanjitc@us.ibm.com), Advisory Software Engineer, IBM

Sanjit Chakraborty is a member of the Down System and Diagnostics Team for IBM Informix Technical Support, which is responsible for handling critical customer situations and developing support tools for use by the Technical Support Organization. Sanjit has worked more than 15 years in the information technology industry in various roles. He is an IBM Certified System Administrator for Informix and DB2, and a designated archiving subject matter expert. Sanjit developed several Informix features and Down System Support tools. He is also an author and technical reviewer of many technical articles, tutorials, and training course materials on various Informix topics.

Summary: In this tutorial, you'll learn about IBM® Informix® Data Warehousing concepts and the tools that you can use to create data warehouses and optimize your data warehouse queries. This tutorial prepares you for Part 7 of the System Administration Certification exam 919 for Informix v11.70.

View more content in this series

Date: 06 Dec 2012
Level: Intermediate
PDF: A4 and Letter (393 KB | 25 pages)Get Adobe® Reader®

Activity: 4717 views
Comments:

Before you start

About this series

Thinking about seeking certification on System Administration for IBM Informix version 11.70 (Exam 919)? If so, you've landed in the right spot to get started. This series of IBM Informix certification preparation tutorials covers all the topics you'll need to understand before you read that first exam question. Even if you're not seeking certification right away, this set of tutorials is a great place to start learning what's new in IBM Informix 11.70.

About this tutorial

In this tutorial, you'll learn about Data Warehousing concepts, strategies, utilities, and commands. The material provided here primarily covers the objectives in Section 7 of the exam, entitled Warehousing. Topics covered in this tutorial include the following.

Multi-index scans
Star join optimization
Fragment by list and interval
Fragment-level statistics
MERGE statement
External tables

Objectives

After completing this tutorial, you should be able to do the following.

Know the concepts and usages of Data Warehousing.
Understand the multi-index scans concept.
Increase query performance with the star join optimization feature.
Understand the use of fragmentation with Data Warehousing.
Take advantage of combine update, insert, and delete operations into a single statement.
Understand the use of an external table.

Prerequisites

To understand the material presented in this tutorial you must be familiar with the following.

The Informix environment (Configuration file and parameters, installation, and administration).
Database server commands (onstat, onmode, oncheck, dbschema).
Informix concepts and terminology (dbspaces, chunks, physical log, logical logs, checkpoint, and so on).

System requirements

You do not need a copy of Informix to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of Informix Innovator-C Edition to work along with this tutorial.

Comments