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

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

how can we join one oracle & flat files ?

2 Answers   ME,

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

How to read the length of word in unix?

0 Answers   CTS,

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

For more Data Stage Interview Questions Click Here
Categories