Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are steps required to ENTER DATA INTO DWH?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to display employee records who gets more salary than the average salary in the department?

1065


Explain an exception?

993


What is the use of oracle?

1030


Why is oracle used?

938


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355


What is a package ? What are the advantages of package ?

1091


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145


Differentiate between translate and replace?

1116


How to execute a stored procedure in oracle?

1091


How to check the server version in oracle?

1092


How different is ms access and oracle?

1037


What to do if the binary spfile is wrong for the default instance?

1069


What are the different types of synonyms?

1140


How to run queries on external tables?

1046


How to use subqueries with the in operator using oracle?

1091