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
Suppose we want to display zero when null values coming to report how can we do that?
Explain what is the data type of the surrogate key?
What is called dimensional modelling?
Explain what are components of report studio?
What are the data marts?
What is the difference between Datawarehouse and OLAP?
What is mean by aggregate aware?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain multivalued dependency?
Where the applications and where ware house management system is used?
Explain degenerate dimension table?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the vaious etl tools in the market?
What is data stream and data adaopter. Is it same are different? Explain?
What is difference between e-r modeling and dimensional modeling?