Answer / subhash

executing the sql query through unix:

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

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

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

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.

Answer / jaini

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

How can you join flat file, oracle as a sources?

4 Answers   IBM,

Define oconv () and iconv () functions in datastage?

0 Answers  

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

what is executable in DataStage?

2 Answers  

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

Differentiate between validated and Compiled in the Datastage?

0 Answers  

What is active and passive stage?

0 Answers