P1: FCH/SPH P2: FCH/SPH QC: FCH/SPH T1: FCH
WY046-FM WY046-Kimball-v4.cls August 18, 2004 13:42
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
2004 by Wiley Publishing, Inc. All rights reserved.
Published simultaneously in Canada
Printed in the United States of America
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any
form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, ex-
cept as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either
the prior written permission of the Publisher, or authorization through payment of the appropriate
per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978)
750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the
Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317)
572-3447, fax (317) 572-4355, e-mail: email@example.com.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations
or warranties with respect to the accuracy or completeness of the contents of this work and specif-
ically disclaim all warranties, including without limitation warranties of ﬁtness for a particular
purpose. No warranty may be created or extended by sales or promotional materials. The advice
and strategies contained herein may not be suitable for every situation. This work is sold with
the understanding that the publisher is not engaged in rendering legal, accounting, or other pro-
fessional services. If professional assistance is required, the services of a competent professional
person should be sought. Neither the publisher not the author shall be liable for damages arising
herefrom. The fact that an organization or Website is referred to in this work as a citation and/or
a potential source of further information does not mean that the author or the publisher endorses
the information the organization or Website may provide or recommendations it may make. Fur-
ther, readers should be aware that Internet Websites listed in this work may have changed or
disappeared between when this work was written and when it is read.
For general information on our other products and services please contact our Customer Care
Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993
or fax (317) 572-4002.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print
may not be available in electronic books.
Library of Congress Cataloging-in-Publication Data
The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and
delivering data / Ralph Kimball, Joe Caserta.
1. Data warehousing. 2. Database design. I. Caserta, Joe, 1965- II. Title.
Trademarks: Wiley, the Wiley Publishing logo, and related trade dress are trademarks or registered
trademarks of John Wiley & Sons, Inc. and/or its afﬁliates. All other trademarks are the property
of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor
mentioned in this book.
eISBN 0-7645-7923 -1