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
How to display employee records who gets more salary than the average salary in the department?
Explain an exception?
What is the use of oracle?
Why is oracle used?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is a package ? What are the advantages of package ?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Differentiate between translate and replace?
How to execute a stored procedure in oracle?
How to check the server version in oracle?
How different is ms access and oracle?
What to do if the binary spfile is wrong for the default instance?
What are the different types of synonyms?
How to run queries on external tables?
How to use subqueries with the in operator using oracle?