Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7461 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kaki
OLTP
1. Normalized database; having lot of joins. Hence, slow
2. INSERT, UPDATE, DELETE immediately refelects data in the
OLTP transactional database.
OLAP
2. Denormalized database; having lesser joins. Hence,
performance is good.
3. Need a tool like ETL to populate the database; Data may
not be seen immediately after creation unless ETL populates
it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivas
OLTP(ONLINE TRANSACTION PROCESSING SYSTEM):
1. It is used for transaction processing.
2. tables and joins are complex.
3. entity relation models will use.
4. used for write operations.
5. performance is low.
OLAP(ONLINE ANALATYCIAL PROCESSING SYSTEM):
1. It is used for analytacial prcessing.
2. tables and joins are simple.
3. dimension modeling will use.
4. used only for read operations.
5. performance is high.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankit kansal
OLTP systems are designed to handle events (Inserts,Update,Delete) frequently so its better to keep your database more normalized form as selection is not as frequent where as in case of
OLAP systems are designed purely for analysis or to find out trends using historical data so, to achieve this kind of functionality a data warehouse are designed more de-normalized where query(selection) is much faster.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the different Reporting and ETL tools available in the market?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is Data Vault???
Explain do we need an etl tool? When do we go for the tools in the market?
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
What are the ETL Testing Operations?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
what is session partitioning?
how many maximum session supports to multiload in teradata ??
Teradata 
