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 can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Differentiate between data file and descriptor file?
what is the use of materialized view?
How to manage date conversion in Datastage?
What are the primary usages of datastage tool?
How many types of views are there in a datastage director?
describe the Steps to confiure a Qlogic switch
What are the difference types of stages?
Can you explain players in datastage?
What are the types of views in datastage director?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How to reverse the string using unix?
What are data elements?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Explain connectivity between datastage with datasources?