Find, Load, and Manage Any Data, Anywhere

The Informatica data warehousing solution provides robust features that enable IT organizations to readily and cost-effectively scale up data marts and departmental data warehouses to be enterprise data warehouses.

Basic Data Warehousing Features

Universal Data Access

• Enables data marts, data warehouses, and enterprise data warehouses to be built using any and all enterprise data
• Provides universal access to:
  • Relational data
  • Legacy data
  • Mainframe and midrange data
  • Application data
  • Messaging data
  • Unstructured data (e.g., Word documents, email, binary files, Microsoft Excel spreadsheets)
  • Semi-structured data (e.g., XML and industry-specific standards, including EDI, HIPAA, HL7, ACORD, FIX, SWIFT)

Cross-Functional Collaboration Tools

• Facilitate collaboration between architects and developers, and between analysts and developers
• Accelerate and standardize design using a data-flow design tool based on Microsoft Visio and mapping templates
• Create mapping specifications in Microsoft Excel and generate Informatica data integration mappings from them

Comprehensive Data Quality Management

• Ensures that all data in data marts, data warehouses, and enterprise data warehouses is complete, consistent, accurate, and current, regardless of its origin
• Builds comprehensive data quality processes into data warehousing projects, including:
• Data profiling
• Data cleansing/matching
• Data quality management and monitoring

Granular User Management and Security Framework

• Defines transformations using a simple “drag and drop” process
• Centralizes all configuration and monitoring tasks
• Helps ensure that all warehoused data is trusted, certifiably accurate, and secure
• Enforces segregation of duties for compliance purposes to control design and development processes
• Manages versioning across multiple usage groups among data warehousing teams for high productivity

Metadata Management

• Enables the auditing and tracing of data in data marts, data warehouses, and enterprise data warehouses
• Documents data definitions and relationships, enabling impact analysis and better control of design and review phases of data warehousing
• Provides a business glossary of clear and consistent data definitions useful to both the business and IT
• Provides visibility into and business context for data and its relationships across all types of applications and systems

Enterprise Grid and Pushdown Optimization

• Boosts the performance of data marts, data warehouses, and enterprise data warehouses by increasing their speed, efficiency, and reliability
• Allows organizations to use resources of a grid environment by distributing sessions across multiple nodes
• Ensures seamless failover and recovery of stopped/interrupted work to maintain data warehouse uptime
• Simplifies setup and management through a configurable services framework
• Enables processing to be “pushed down” into a relational database
• Provides hybrid ETLT capabilities that enhance flexibility and utilization of the database for a data warehouse

Extended Features for Enterprise Data Warehousing

Real-Time Data Integration

• Enables data warehouses and enterprise data warehouses to deliver data in real time and in any other latency, including batch and changed data
• Guarantees message delivery via Web services

Data Services

• Serves as a logical abstraction layer between data sources and consuming applications
• Decouple data warehouses from business intelligence applications, freeing warehouses to serve diverse applications

Informatica Velocity Methodology

• Provides IT teams with best practices in integration skills, processes, and technology so they can complete data warehouse projects consistently, rapidly, and cost-effectively
• Aligns business and IT to create more efficient and productive data warehouses