Etl Slowly Changing Dimensions

Page 1

Contents

I. II. Executive Summary ......................................................................................................................... 3 Overview .......................................................................................................................................... 3

III. Background ...................................................................................................................................... 4 IV. Informatica PowerCenter ................................................................................................................. 6 A. V. A. B. C. Details for Type 2 Slowly Changing Dimension ...................................................................... 7 Talend .............................................................................................................................................. 9 Talend-Provided SCD Component ......................................................................................... 9 Self-Designed SCD Type 1 Update Process ........................................................................10 Factors Affecting the Performance of Updates .....................................................................11

VI. Ab Initio ..........................................................................................................................................11 VII. Conclusion .....................................................................................................................................12 VIII. About Lunexa .................................................................................................................................12

301 Howard Street, Suite 1410 * San Francisco, CA 94105 U.S.A. * Phone 415.325.5902 * Fax 415.358.4626 * www.lunexa.com Copyright © 2011 Lunexa, LLC Page 2

I.

Executive Summary

Maintaining Slowly Changing Dimensions often poses a difficult challenge for extract,...