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 we can covert server job to a parallel job?
How you can fix the truncated data error 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?
Difference between server jobs & parallel jobs?
What is ibm datastage flow designer?
What are the features of datastage flow designer?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the functionalities of link partitioner and link collector?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the different common services in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
whom do you report?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How and where you used hash file?
How many Key we can define in remove duplicate stage?