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

how can u connect the client system directly at any time?

1 Answers   IBM,

What is a merge in datastage?

0 Answers  

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

How many types of views are there in a datastage director?

0 Answers  




What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

Highlight the main features of datastage?

0 Answers  

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

How we can convert rows to columns in datastage?

4 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories