Tip : Query to get latest records from scd type2 product dimension table in DWH using kettle

SELECT * FROM  cdc_timestamp_scd_product_target;

SELECT * FROM cdc_timestamp_scd_product_target

WHERE sk!=0

AND sk IN (SELECT MAX(sk) FROM cdc_timestamp_scd_product_target WHERE sk!=0 GROUP BY product_id)