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
- 12718 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 aggtorec restructure operator?
What are the types of hashed files in data stage
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you import and export the datastage jobs?
Where do the datastage jobs get stored?
How to implement complex jobs in data stage?
Can you explain kafka connector?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Have you used Unstructured data?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the purpose of interprocessor stage in server jobs?
What is the difference between odbc and drs stage?
in oracle target stage when we use load option and when we use upsert option?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
