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...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

what is the difference between OLTP database and data
warehousing database?

Question Posted / jteo

Answer Posted / jteo

OLTP (Online Transaction Processing) database design is
normalised, which means it is optimized for INSERT, UPDATE.

Data warehouse design is not normalised but follows
dimensional modelling rules. They involve building star
schemas made up of fact tables and dimension tables and are
optimized for querying (SELECT).

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2488

Define Dynamic push down optmization?

2242

Do we need an ETL tool? When do we go for the tools in the market?

892

Difference between flat files and relational sources?

2223

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2311

What is etl tool in hadoop?

839

What are the names of the layers in etl?

941

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2061

where are the log files generally stored.Can you change the path of the file.what can the path be?

2374

what is the use of server manager?

2059

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2434

Explain about round-robi?

1080

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4050

What is data cleaning?

889

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2060