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
Can multiple columns be used in group by in oracle?
How to connect asp pages to oracle servers?
What is Java Pool in Oracle?
What do you know about normalization? Explain in detail?
What to do if dba lost the system password?
How to rename a column in an existing table?
How to create a new view in oracle?
What is BBED in Oracle?
What is backup in Oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to add a new column to an existing table in oracle?
How to upsert (update or insert into a table)?
What is the difference between $oracle_base and $oracle_home?
How to see free space of each tablespace?
What is a cognitive schema?