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
how to delete one row in target dataset
How do you schedule or monitoring the job?
How to RD using transformer?
Explain datastage architecture?
What are the different types of lookups in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
root tree will find which is server job and which is parallel job?
Can you explain players in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
describe the Steps to confiure a Qlogic switch
What are data elements?
What is the difference between in process and inter process?
sed,awk,head
What are the different type of jobs in datastage?
On which interface you will be working as a developer?