How to load in old n new data , and use where not exists?
I want o use Where not Exists for my Order and New Order table.
I have loaded Order_Table and I have transformed and added some new field. Then found out i have another New_Order table which vae some new records need to load in as well. So i wrote the script below. But when i reloaded it, it created Syntetci key.
How to avoid that and able to load in both Order and New Order table records?
EmployeeID &'|' & Year as order_key,
Month(OrderDate) as Month,
APPLYMAP('Product_Details',ProductID,'ProductID Not Available in Product Details') as Product_Made,
//APPLYMAP('Product_Details',ProductID,null()) as Product_Made,