Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7426 Views
- I also Faced
- E-Mail Answers
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
Is apache nifi an etl tool?
dimension object created in oracle can be imported in designer?how?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What is a staging area? What is the purpose of a staging area?
What is tracing level? How many types of transformations supported by sorted input?
how do u set partition points in the mapping?
Explain and compare etl & manual development?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
list and discuss two approaches for updation of target table in Informatica and how they are different.
What are the modules in Power Mart?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how does the server recongnise the source and target databases.Elaborate on this
Explain about the data integration suite features?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
can cubes contain measures ?
