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 create an oracle database manually?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to retrieve values from data fields in record variables?
What are the ansi data types supported in oracle?
Explain the use of control file?
How data locks are respected in oracle?
How to return top 5 rows in oracle?
What is oracle database client?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to create an oracle database?
What is rich query?
What is oracle join syntax?
How to assign values to variables?
Why use resource manager in Oracle?
Explain constraining triggers.
