ETL Using Pentaho(Spoon)

Created Feb. 7, 2024 by Girija Narasimhan

Introduction

 Slowly changing dimension Type 1 (update) also similar like slowly changing dimension type1 (insert), but it never store the previous value of the record or previous history, it will keep only new record information or updated value.

SCD Type 1 (Updated)

From Step 1 ....Step 9 all the similar like Unit 2 SCD Type1 (Insert), Step 10 onwards mapping the fields minor changes in the data integration.





Return to top