connect to sqlplus from unix typing sqlplus user name:user_name@database password: then type @pathname of the file containing sql query\sql query file name.sql
Primary Key for the dimension table is its own primary Key Primary Key for Fact table is Foreign key which derived from Dimensional table
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!