| March 03, 2008 00:55:57 |
#3 |
| praveen.p |
Member Since: September 2007 Total Comments: 2 |
RE: Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended
|
| I think the more specific and technical answer would be the noremalized and denormalized form of data that exists in OLTP and OLAP machines. In OLTP machine you want to keep the data normalized because you want the transaction or the machine to be fast. In OLAP machine you want to keep the data denormalized because the of the complex Querying by the DSS tools. |
| |
