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 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,

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

How many types of stage?

0 Answers  

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

0 Answers  

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

What are the processing stages?

0 Answers  

Differentiate between Join, Merge and Lookup stage?

0 Answers  

What is the difference between validate and compile?

1 Answers   CTS,

How can we achive parallelism

1 Answers   CTS,

what is factless fact table?

3 Answers   IBM,

What is difference between server jobs & parallel jobs?

0 Answers  

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers