INTERVIEW QUESTIONS DATA WAREHOUSING GENERAL DATAWAREHOUSING DETAILS

Question: Why should you put your data warehouse on a different system than your OLTP system?

Answer: A OLTP system is basically " data oriented " (ER model) and not " Subject oriented "(Dimensional Model) .That is why we design a separate system that will have a subject oriented OLAP system...

Moreover if a complex querry is fired on a OLTP system will cause a heavy overhead on the OLTP server that will affect the daytoday business directly.

Submitted by Vijayaraghavan.C ( [email protected] )

_____________

The loading of a warehouse will likely consume a lot
of machine resources. Additionally, users may create
querries or reports that are very resource intensive
because of the potentially large amount of data
available. Such loads and resource needs will
conflict with the needs of the OLTP systems for
resources and will negatively impact those production systems.

Submitted by Richard Clough ([email protected])

A OLTP system is basically " data oriented " (ER model) and not " Subject oriented "(Dimensional Model) .That is why we design a separate system that will have a subject oriented OLAP system...

Moreover if a complex querry is fired on a OLTP system will cause a heavy overhead on the OLTP server that will affect the daytoday business directly.

Submitted by Vijayaraghavan.C ( [email protected] )

_____________

The loading of a warehouse will likely consume a lot
of machine resources. Additionally, users may create
querries or reports that are very resource intensive
because of the potentially large amount of data
available. Such loads and resource needs will
conflict with the needs of the OLTP systems for
resources and will negatively impact those production systems.

Submitted by Richard Clough ([email protected]) Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question