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.

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

What are the features of datastage flow designer?

0 Answers  

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

how to abort the job its matain duplicates?

0 Answers   TCS,

Describe the main features of datastage?

0 Answers  

What is the roundrobin collector?

0 Answers