Interested to Buy Any Domain ? << Click Here >> for more details...
What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7837 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 |
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Can we save images in a database and if yes, how?
What is varray?
What is the difference between formal parameters and actual parameters?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are the attributes that are found in a cursor?
What is the difference between "as" and "is" in an oracle stored procedure?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to see the table columns used in an index?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
Oracle General 
