Chapter 9, Performing Advanced Operations with Databases
Pop quiz – implementing a Type III SCD in PDI
|
Q1 |
2 (1) is not a valid option. The Dimension L/U by itself is not prepared to maintain the previous value and the current value in the same record automatically. There are very few things you cannot do with PDI if you have to work with data, so (3) is out of discussion. The right answer is (2). With a Database lookup to get the current value stored in the dimension. If there is no data in the dimension table, the lookup fails and returns null; that is not a problem. After that, you compare the found data with the new one and set the proper values for the dimension columns. Then, you load the dimension either with a Combination L/U or with a ... |
Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
