Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / vijay

Answers were Sorted based on User's Feedback



How can u execute the sql query through unix? What is the Primary key for Dimension table? what is..

Answer / subhash

executing the sql query through unix:

sqlplus -s <userName>/<passWord>@<HostName> <<EOF >
testData.txt
set pagesize 0
select sysdate from dual;
EOF

Is This Answer Correct ?    7 Yes 0 No

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is..

Answer / paramita biswas

connect to sqlplus from unix
typing sqlplus
user name:user_name@database
password:
then type
@pathname of the file containing sql query\sql query file
name.sql
eg:@path\file.sql
press enter

Is This Answer Correct ?    4 Yes 0 No

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is..

Answer / bala

Primary Key for the dimension table is its own primary Key
PRimary Key for Fact table is Foriegn key which dirived from
Dimensional table

Is This Answer Correct ?    5 Yes 2 No

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is..

Answer / 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

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is..

Answer / jaini

In order to execute an sql query thru unix, simply write db2 "sql query" and press enter.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Data Stage Interview Questions

Describe the main features of datastage?

0 Answers  

How rejected rows are managed in datastage?

0 Answers  

Can you highlight the main features of ibm infosphere information server?

0 Answers  

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

What are the components of datastage?

0 Answers  

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

For more Data Stage Interview Questions Click Here
Categories