what is the difference between OLTP database and data
warehousing database?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use lookup tables and Aggregate tables?
what are the production issues in datastage?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what is different between sequential batch and concurrent batch and which is recommended and why?
What are the ETL Testing Operations?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is pmrep command?
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 is the use of server?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is tracing level and what are the types?
Is hadoop a etl tool?
Explain what are the various etl tools in the market?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
how do u really know that paging to disk is happening while u are using a lookup transform?