Answer Posted / mohammad
1. Develop .sql file to extract data from RT to temporary
location
2. Transfer data from Temporary loaction to DWH
3. Load thses data to DWH
4. Internally mininig data and refresh Materialized view
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What happens if recursive calls get out of control?
What is the meaning of recursive hints in oracle?
How to use "in out" parameter properly?
How to create a single index for multiple columns?
How do I manually create a database in oracle?
Explain view?
How to get a list of all background sessions in the database?
How to change program global area (pga) in oracle?
What is a package in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How index is implemented in oracle database?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the restrictions on external table columns?
What is the data type of dual table?