Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11915 Views
- I also Faced
- E-Mail Answers
Answer Posted / shrihari
data warehouse is often use denormalized schema to optimize
query perfomance.
OLTP sytem often use fully normalized schema to optimize
update, insert, delete perfomance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of data warehousing?
What is load manager?
What is pre-emptive and non-pre-emptive?
Explain what is the difference between datawarehouse and bi?
What is degenerate dimension table?
How many types of facts and what are they?
What are partition points?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain what is the difference between a primary and secondary actor in use case modeling?
Start a batches with in a batch?
How to import vsam files from source to target. Do we need a special plugin?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are the different models used in cluster analysis?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What are Non-additive facts?
