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 / nish
how to execute SQL query through unix.
This is a generic question. You need to use the Command line utility provided by the DBMS
For oracle; SQL plus
DB2: DB2 CLI
others : as provided by the product.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you import and export the datastage jobs?
What are the types of jobs we have in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the difference between orabulk and bcp stages?
What is the use of datastage designer?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Demonstrate experience in maintaining quality process standards?
what is ds administrator used for?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Why we use surrogate key?
Explain entity, attribute and relationship in datastage?
How to RD using transformer?
Which warehouse using in your datawarehouse
How to convert RGB Value to Hexadecimal values in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?