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 are the predefined tablespaces in a database?
Explain how you would restore a database using RMAN to Point in Time?
How do we create privileges in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How data locks are respected in oracle?
How to write an inner join with the where clause in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
does the query needs a hint to access a materialized view?
What types of joins are used in writing subqueries?
How do I limit the number of oracle database connections generated by weblogic server?
How many types of tables are there in oracle?
What is a table in oracle?
What is set verify off in oracle?
What are the execution control statements in oracle?
How to insert a new row into a table in oracle?