How can u execute the sql query through unix?
What is the Primary key for Dimension table?
what is the primary key for Fact table?
Answer Posted / paramita biswas
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
press enter
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of datastage?
What is a quality stage in datastage tool?
What are the various kinds of containers available in datastage?
What is datastage engine?
What is the difference between operational data stage (ods) and data warehouse?
sed,awk,head
options available in sequence job to run,validate?
describe the Steps to confiure a Qlogic switch
What is the different type of jobs in datastage?
which r the connectors used in san?
Can you explain how could anyone drop the index before loading the data in target in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How to perform incremental load in datastage?
Explain Quality stage?