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


Please Help Members By Posting Answers For Below Questions

Which warehouse using in your datawarehouse

1680


Differentiate between datastage and datastage tx?

591


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1801


What is the difference between datastage and datastage tx?

590


Enlist various types of routines in datastage.

643






What is active and passive stage?

876


Explain the situation where you have applied SCD in your project?

1558


Define meta stage?

779


what are the devoleper roles in real time? plz tell i am new to datastage....

1635


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

545


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2701


How do you generate sequence number in datastage?

623


Differentiate between validated and Compiled in the Datastage?

639


What is the difference between validated and compiled in the datastage?

699


How to convert RGB Value to Hexadecimal values in datastage?

3455