What is the difference between a W/H and an OLTP application?
Answer Posted / bindu
W/H maintains subjectoriented,timevariant,histrorical data.
where as OLTP apllications maintains current data, and it
gets updates regularly. ex:ATM machine,Railway reservations
etc.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a data warehousing?
What is fact less fact table? Where you have used it in your project?
What is data validation strategies for data mart v?
What is core dimension?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain what are components of reportnet?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
How to calculate fact table granularity?
Explain what is the extension of file to save template?
What are the stages of datawarehousing?
Can you pass sql queries in filter transformation?
Explain what is full load & incremental or refresh load?
Explain what is real time data-warehousing?
Fact table is in normalized or de-normalized form?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?