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 |
what are Triggers?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is a relational database management system?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
How different is ms access and oracle?
What are the differences between char and varchar2 in oracle?
What is Public Database Link ?
How to use "if" statements on multiple conditions?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What privilege is needed for a user to create views in oracle?
Youre getting high busy buffer waits - how can you find whats causing it?
What are the attributes that are found in a cursor?