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

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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different common services in datastage?

1214


What are the functionalities of link partitioner?

971


what is repositery?

1767


What are stage variables?

1138


What are the benefits of datastage?

1173


What are the processing stages?

1039


How many types of stage?

1131


What is the command line function to import and export the ds jobs?

1095


What are the main features of datastage?

1205


What are routines in datastage? Enlist various types of routines.

1047


What is the difference between an operational datastage and a data warehouse?

1088


Explain the situation where you have applied SCD in your project?

1972


What are datastage sequences?

1056


how many rows sorted in sort stage by default in server jobs

3929


Differentiate between data file and descriptor file?

988