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 a new table in your schema?
How index is implemented in oracle database?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain the truncate in oracle?
Explain about functional dependency and its relation with table design?
Difference between the “verify” and “feedback” command?
what is port in oracle? how is it related to database application.
How to create a table index?
Whether any commands are used for months calculation? If so, what are they?
What is primefaces used for?
What is oracle data type?
How to list all user accounts in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How to create a stored function in oracle?
Explain cascading triggers.