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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to delete one row in target dataset

3061


How do you schedule or monitoring the job?

1133


How to RD using transformer?

1363


Explain datastage architecture?

1332


What are the different types of lookups in datastage?

1006


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2208


root tree will find which is server job and which is parallel job?

1882


Can you explain players in datastage?

1142


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331


describe the Steps to confiure a Qlogic switch

2327


What are data elements?

1104


What is the difference between in process and inter process?

1090


sed,awk,head

1408


What are the different type of jobs in datastage?

1002


On which interface you will be working as a developer?

986