You want to manage a slowly changing dimension as type II.

You want to manage a slowly changing dimension as type II.

Which step in PDI should you use to accomplish this task.
A . The ‘Shared Dimension’ step
B . The ‘Dimension Lookup/update’ step
C . The ‘Combination lookup/update’ step
D . The ‘Table output step

View Answer

Answer: D