Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

how to convert rows into columns

2 Answers   IBM,

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

Define repository tables in datastage?

0 Answers  

What are the different common services in datastage?

0 Answers  

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

7 Answers   IBM,

what is operator combinality in datastage?

1 Answers   TCS,

What is the default padding character?

3 Answers   IBM,

client know skid info?

0 Answers   NTT Data,

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

Describe the architecture of datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories