Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 12360 Views
- TCS, I also Faced
- E-Mail Answers
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
Why do you need stage variables?
how do u catch bad rows from OCI stage? And what CLI stands for?
Explain ibm infosphere information server and highlight its main features?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Different ways a project can be moved to production ?...example ….export-import and Version control.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the different type of jobs in datastage?
What is ibm 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
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
table actions available in oracle connector?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the flow of loading data into fact & dimensional tables?
Can you explain engine tier in information server?
