Temporal Join.txt

-- TEMPORAL JOIN--___________________________ create column table "anoop11"."PRODUCT_MASTER_TEMP" ( "P_ID" integer, "P_NAME" Nvarchar(30), "VALIDITY_FROM" DATE, "VALIDITY_TO" DATE ); INSERT into "anoop11"."PRODUCT_MASTER_TEMP" VALUES (1,'Nokia E6','20150101','20150201'); INSERT into "anoop11"."PRODUCT_MASTER_TEMP" VALUES (2,'MOTO G4','20150301','20150401'); INSERT into "anoop11"."PRODUCT_MASTER_TEMP" VALUES (3,'HTC 828','20150501','20150601'); create column table "anoop11"."PRODUCT_SALES_TEMP" ( "P_ID" integer, "SALES_DATE" DATE, "UNIT_SOLD" integer, "REVENUE" integer ); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (1,'20150101',112,1512000); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (1,'20150205',26,351000); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (1,'20150116',12,162000); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (2,'20150221',106,1325000); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (2,'20150301',23,218500); INSERT into "anoop11"."PRODUCT_SALES_TEMP" VALUES (2,'20150331',35,332500); INSERT INSERT INSERT INSERT INSERT INSERT

into into into into into into

"anoop11"."PRODUCT_SALES_TEMP" "anoop11"."PRODUCT_SALES_TEMP" "anoop11"."PRODUCT_SALES_TEMP" "anoop11"."PRODUCT_SALES_TEMP" "anoop11"."PRODUCT_SALES_TEMP" "anoop11"."PRODUCT_SALES_TEMP"

VALUES VALUES VALUES VALUES VALUES VALUES

(2,'20150406',46,437000); (3,'20150411',89,890000); (3,'20150501',87,870000); (3,'20150608',91,910000); (3,'20150623',102,1020000); (3,'20150116',64,640000);