Interested to Buy Any Domain ? << Click Here >> for more details...
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
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
When do we use group by clause in a sql query?
How to create a new oracle data file?
What are the different types of database objects?
Give syntax for SQL and ORACLE joins.
How to assign a table row to a record variable?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How can we view last record added to a table?
Which is faster join or subquery in oracle?
Is truncate autocommit in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to define and use table alias names in oracle?
How to define an external table with a text file?
How a database is related to tablespaces?
What are the differences between interval year to month and interval day to second?
