Interested to Buy Any Domain ? << Click Here >> for more details...
What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7847 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 to use "in out" parameter properly?
what is the use of system.effective.date variable in oracle?
How to check the oracle tns settings?
Can we create more than one constraint to column ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is oracle data type?
What is a user role in oracle?
what r tyhe major differences between oracle 9i & 10g?
Is the After report trigger fired if the report execution fails ?
How to connect ms access to oracle servers?
How to select some rows from a table in oracle?
Oracle General 
