Informatica's mapping tool is used to pull data from the various transaction systems and load it into the data warehouse. This 15-gigabyte warehouse contains customer data ranging from travel reservation history, membership history, insurance product sales and Web click streams. IT staff, business managers and executives regularly access the warehouse. AAA Carolinas uses the Brio Broadcast Server to schedule large, complex queries and reports to run overnight so users have their results when they arrive in the morning. Both IT and user created reports are stored on a central server for others to either view or modify for their own use.
Many queries require fresh transaction data in addition to monthly warehouse data.
Brio makes that task surprisingly simple. A single query accesses all the required databases and combines results into one report for further analysis and distribution. Brio is gathering data from both the warehouse and operational systems to see if data is loading accurately. This feature has saved countless hours and allowed the warehouse to go into production sooner than expected. In just one week, AAA Carolinas was completely functional with Brio.