Temporal Join.docx

AIM: HOW TO CREATE TEMPORAL JOIN PROCEDURE: STEP1: GOTO HANASTUDIO->EXPAND THE SYSTEM ->SELECT THE SCHEMA RIGHT CLICK ON THAT SELECT NEW TABLE

CLICK ON EXECUTE STEP 2: INSERT VALUES INTO THE TABLES

STEP 3: CREATING ANOTHER TABLE

STEP 4: INSERT VALUES INTO THE TABLE insert into "HANAUSER"."EMPSALES" values('001','2013-12-31',20000); insert into "HANAUSER"."EMPSALES" values('002','2014-01-31',30000); STEP 5: CREATING ATTRIBUTE VIEW RIGHT CLICK ON THE PACKAGE->NEW->ATTRIBUTE VIEW AND GIVE THE NAME OF THE PACKAGE

CLICK FINISH STEP 6: DRAG AND DROP THE TABLE TO THE DATA FOUNDATION AND SELECT THE COLUMNS FOR OUTPUT

STEP 7: SELECT THE SEMANTIC OF THE VIEW AND SELECT KEY ATTRIBUTE

STEP 8: SAVE AND VALIDATE,SAVE AND ACTIVATE THE VIEW STEP 9: CREATING ANALYTICAL VIEW RIGHT CLICK ON THE PACKAGE->NEW->SELECT THE ANALYTICAL VIEW AND GIVE NAME OF THE VIEW

CLICK FINISH STEP 10: SELECT THE DATA FOUNDATION AND ADD THE EMPSALES OBJECT TO THE DATAFOUNDATION AND SELECT COLUMNS STEP 11: SELECT THE LOGICAL JOIN ADD THE ATTRIBUTE VIEW TO THE LOGICAL JOIN AND JOIN THE DATAFOUNDATION TO THE ATTRIBUTE VIEW

STEP 12: SELECT THE JOIN AND CHOOSE FOLLOWING INFORMATION

STEP 13: CLICK ON SAVE AND VALIDATE ,SAVE AND ACTIVATE THE VIEW

STEP 14: CLICK ON THE DATA PREVIEW OPTION TO VIEW THE RESULT EMPLOYEE TABLE DATA :

EMPSALES TABLE DATA :

FINAL OUTPUT: