PowerMart of Informatica

1
PowerMart of Informatica

• ??? ???(992COG05)
• sk.kim_at_ewha.ac.kr
• ??? March 27th , 2000

2
contents

• Informatica ??
• PowerMart ??
• PowerMart ?? ??
• PowerMart? ??
• PowerMart? ???

3
Informatica ??

• Cofounder Dhillon and Nesamoney
• History
• 1993, in a small spare bedroom
• 1994, introducing Open Bridge
• 1996, releasing PowerMart after much
  fine-tuning and 2.5 million in venture funding
• 1999, 362 employees
• Major clients Oracle, Microsoft, Sybase,etc.
• Location Palo Alto, California
• Web http//www.informatica.com/

4
PowerMart ??

• An integrated suite of software products building
  and managing line-of-business data marts and
  analytic applications.
• PowerMart Designer
• Source Analyzer
• Warehouse Designer
• Mapping Designer
• Transformation Developer
• PowerMart Repository
• PowerMart Repository Manager
• PowerMart Server Manager
• PowerMart Server

5
PowerMart ?? ??

• Scalable pipeline processing(SPP)
• production deployment automation
• Flat file acceleration
• Business component framework(BCF)
• Advanced session management
• Multi-level security
• Fault-tolerant recovery
• Session creation
• New browser functionality

6
Platform Informatica's products run on Windows
95/NT and UNIX and support IBM DB2, Informix,
Oracle, Sybase, Microsoft SQL Server, IMS, VSAM,
ODBC, flat file and other operational sources.
7
PowerMart ??

• Delivering an open, scalable solution that
  addresses the complete life cycle for data mart
  and anlytic development, production, and ongoing
  management.
• Able to source large volumes of fast changing
  data from multiple platforms, handle complex
  transformations, and support high-speed loads.
• Designing easily complex source to target mapping
  based on GUI by data warehouse administrators.

8

• Executing and Maintaining automatically by
  PowerMarts powerful Server.
• Component-based architecture
• Sharing/reuse capabilities
• compatible with both UNIX and NT allowing the
  company to leverage its existing hardware
  investments
• Retail price 85,000

9
PowerMart? ???

• PowerMart currently has some restrictions
  handling unstructured text-file data sources.
• Its source control could be more efficient,
  making it easier to move repository changes
  across unconnected networks
• PowerMart could improve its flexibility with
  global variables.

10

• 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.
• Documentation was not addressing the transition
  thoroughly. Performance tuning was also an issue
  in the early stages of the project.
• Speed can always be improved.