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)
For Developers: Pentaho BI Suite Tutorials - Place to find tips & tutorials
For Decision Makers: Single stop destination to find insights of your business with No cost
For Decision Makers: Single stop destination to find insights of your business with No cost
Wednesday, 2 August 2017
Tip : Query to get latest records from scd type2 product dimension table in DWH using kettle
SELECT * FROM cdc_timestamp_scd_product_target;
Subscribe to:
Posts (Atom)