PLATFORMS: First American National Bank utilizes Informatica's PowerMart to build and manage the data mart and operational data store, and NCR Teradata and Sybase System 11 databases for data storage.

BACKGROUND: Faced with escalating competition for both retail and corporate customers from within the banking and financial services industries, Nashville-based First American National Bank is counting on data warehousing technology to provide a competitive edge. Having offered traditional banking services for over 100 years to more than a half million customers in the southeastern United States, First American is now looking to grow corporate assets by expanding their offerings to include investment banking and insurance products and services.

PROBLEM SOLVED: First American is using Informatica's PowerMart to extract and transform data from 35 flat-file sources and load the data into a traditional data warehouse and an operational data store. The first warehouse deploys an NCR Teradata relational database and enables business analysts and decision-makers to better understand the banking habits of both retail and corporate banking customers. By running query and reporting software against the warehouse, analysts are able to examine customer trends over time and use neural net analysis for predictions, enabling them to determine the most effective strategies for pricing, packaging, marketing and distributing the bank's products and services. By year-end 1997, First American expects the Teradata warehouse will house 400 gigabytes of raw data. The second warehouse is an Operational Data Store (ODS), built on Sybase System 11. The ODS houses one period of data (currently one month) that enables First American to ask and answer detailed questions about their customers.

PRODUCT FUNCTIONALITY: Informatica PowerMart has given First American's decision support system a significant performance boost, resulting in measurable return on investment. The bank's next step is to begin addressing an even larger warehousing initiative: deploying multiple line-of-business data marts and integrating them into a networked, enterprise-wide decision support system.

STRENGTHS: Informatica's PowerMart enterprise performance and scalability coupled with its ease of use has allowed First American National Bank to build their decision support system with a framework designed for the future. As more subject matters and analysis needs arise, First American plans to leverage PowerMart's scalability features including smart aggregations, intelligent updates and data mart synchronization to build and manage its data warehouse on an incremental basis, growing it across the enterprise to accommodate end users.

WEAKNESSES: Although PowerMart captures meta data throughout the extraction and transformation phases, it does not yet have the capability to network together multiple data marts to form an enterprise view of data.

DELIVERABLES: By implementing Informatica PowerMart 3.5, First American has achieved significant performance improvements. Processing time for transforming and loading one of First American's sources to its target (over 15 million rows of data) has improved 30 percent. First American has noted similar improvements in performance in all of its Informatica processes.

SELECTION CRITERIA: Adequately capturing meta data during transformations was one of First American's key requirements. PowerMart did exactly what was needed, automating the extraction and transformation process and capturing meta data along the way.

VENDOR SUPPORT: Informatica support has been excellent, from consulting services to advice and strategy on future product versions and methodologies.

DOCUMENTATION: Documentation for PowerMart was excellent.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access