Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7648 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain do we need an etl tool?
Define slowly changing dimensions (SCD)?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
When do we analyze the tables? How do we do it?
what is the difference between cardinality and Nullability?
what is pmrep command?
what is dynamic insert?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how to connect to a flatfile through ftp in informatica
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what are the reporting tools and difference between them?
what are the types in error loging?
How to delete data which is not in source table?
