What are steps required to ENTER DATA INTO DWH?
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 |
Explain the use of owner option in exp command.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Point the difference between translate and replace?
How to convert raw data type into text in oracle? Explain
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
How to use subqueries with the exists operator in oracle?
What are the built-in functions used for sending Parameters to forms ?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Why do you use stored procedures and state some of its disadvantages?
What is Oracle table?
how to insert data into partitioned table partition done by Range partition