what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5888 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sanchari chowdhury
Records in a OLTP database can be updated or modified or
deleted. However,the same is not possible in DW.
OLTP database is used for transactional purposes e.g. day-
to-day sales or finance and DW is used for analytical
decisions.DW is mainly used for business decisions to
ensure stability of the organisation by curbing the
possible failures. This is possible because it contains the
historical or the archived data for analysis.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / parvar
The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data
| Is This Answer Correct ? | 0 Yes | 0 No |
What is tracing level and what are the types?
how do use session mapping parameters ?(in which transformation)
What exact we can see in table?
where we cannot use sorter Transformation. if we use then we will not get correct data?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Mention few test cases and explain them?
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 many types of transformations supported by sorted input?
What are the ETL Testing Operations?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are the parts of Informatica server ?
Teradata 
