What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 6757 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 |
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Explain the family trees and connection by clause
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Is there any function in oracle similar like group_concat of mysql?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
what are archived logs?
What is mean by Program Global Area (PGA) ?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Differnce between view and index
Where is the export dump file located?
Oracle General 
