When evaluating a data integration tool, you need to ask whether it handles dimension and fact transformations in a robust manner. You also need to determine how it handles error processing, and captures changes to dimensional data across time. Does it include reusable objects? What late-arriving fact functionality does it provide? And which data stores does it actually connect to?
Read More
|
Many organizations have made enormous investments in enterprise resource planning (ERP) applications such as JDE, PeopleSoft, and SAP. Designed to manage the daily
operations critical to their businesses, these systems are not, however, optimized for business intelligence (BI). Accordingly, data must be moved to optimized BI solutions for robust analysis. But which strategies are most effective for extracting this data?
Read More
|