Interested to Buy Any Domain ? << Click Here >> for more details...
What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7919 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / elsheikh
1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
| Is This Answer Correct ? | 7 Yes | 3 No |
How can we Update a table with out using UPDATE command?
What privilege is needed for a user to connect to oracle server?
What is the difference between count (*), count (expression), count (distinct expression)?
What is Redo Log Buffer in Oracle?
What is primefaces used for?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
How to rename a tablespace in oracle?
sql query to get zero records from a table
What is object data modeling?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What is a static data dictionary in oracle?
where we have to use ON clause and where we have to use USING clause in JOINS
Oracle General 
