There is a perception that if business users are given access to enterprise databases and raw query tools, they will create havoc in the system, which is a possibility—unless the business intelligence (BI) product developer understands the potential problem and addresses it as a business-critical factor.
artificial intelligence in human resources
that DWs create an artificial split between transactions and reporting. Yet, the more data is copied, duplicated, or modified, the less accurate it becomes, and it might be more efficient and cost-effective to correct data problems at the source than to move and modify databases. As another illustration along the Oracle's aforementioned lines, Vanguard's customers reportedly often find that they can drive rapid data quality improvements with the level of visibility that Direct Access brings to their