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?
- 5 Answers
- 12356 Views
- TCS, I also Faced
- E-Mail Answers
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
What is active and passive stage?
What is the purpose of interprocessor stage in server jobs?
What is the flow of loading data into fact & dimensional tables?
Define Merge?
How to clean the datastage repository?
What are the components of datastage?
AGGREGATOR default datatype
What is the use of datastage director?
How many areas for files does datastage have?
What are orabulk and bcp stages?
Notification Activity
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
root tree will find which is server job and which is parallel job?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the areas of application?
