what is the difference between OLTP database and data
warehousing database?
Answer Posted / 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 |
Post New Answer View All Answers
dimension object created in oracle can be imported in designer?how?
What is a mapping?
how does the server recongnise the source and target databases.Elaborate on this
explain the methodology of Data Warehousing?(Polaries)
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is pmrep command?
what do u do when DB time takes more?in sap bi
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is data cleaning?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the different Lookup methods used in Informatica?
When do we go for the tools in the market?
what is Forward,Reverse and Re_engineering?
What is etl process. How many steps etl contains explain with example?
if i have a query as flat file how can we load data to target table