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 is ds administrator used for?

1168


What is the method of removing duplicates, without the remove duplicate stage?

1023


How you Implemented SCD Type 1 & Type 2 in your project?

4129


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188


Differentiate between validated and Compiled in the Datastage?

1275


Define orabulk and bcp stages?

1119


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2209


What is a merge?

1164


How do you start developing a datastage project?

1103


What are the job parameters?

1221


What is ibm datastage?

969


Difference between in process and inter process?

1229


What is the difference between Datastage 7.5 and 7.0?

1094


how to delete one row in target dataset

3118


What are the processing stages?

1099