Hello All,

I need to CREATE a SCD Type 2 Dimension for a table through PDI.I wanted to have all the source columns along with efeective_from and effective_to date with surrogate key.But dont want the version field.

I am using the Pentaho Dimension lookup\update step..Is there any way where we can just ignore the version field and can only have the effective_from and effective_to date columns which will check based on the source last_updated_date column.

Kindly suggest