Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - How can you execute the sql query through Unix? What is the Primary key for Dimension table? what is the primary key for Fact table?




775
views
asked mar September 20, 2014 06:32 AM  

How can you execute the sql query through Unix? What is the Primary key for Dimension table? what is the primary key for Fact table?


           

1 Answers



 
answered By vishnoiprem   0  

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

eg:@path\file.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

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert