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 to clean the datastage repository?
Explain ibm infosphere information server and highlight its main features?
What a datastage macro?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the sortmerge collector?
What are the types of containers?
What are the different types of lookups in datastage?
Can you explain tagbatch restructure operator?
Describe link sort?
What are some different alternative commands associated with "dsjob"?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the steps needed to create a simple basic datastage job?
What could be a data source system?
What steps should be taken to improve Datastage jobs?
What are iconv and oconv?