Power Mart of Informatica 992 COG 05 sk

Power. Mart of Informatica 발표자 : 김수경(992 COG 05) sk. kim@ewha. ac. kr 발표일 : March 27 th , 2000

contents n n n Informatica 소개 Power. Mart 특징 Power. Mart 주요 기능 Power. Mart의 장점 Power. Mart의 개선점

Informatica 소개 n n Cofounder : Dhillon and Nesamoney History : n n n n 1993, in a small spare bedroom 1994, introducing “Open Bridge” 1996, releasing “Power. Mart” after much finetuning 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/

Power. Mart 특징 n An integrated suite of software products building and managing line-of-business data marts and analytic applications. n Power. Mart Designer n n n n Source Analyzer Warehouse Designer Mapping Designer Transformation Developer Power. Mart Repository Manager Server

Power. Mart 주요 기능 n n n n n 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

Platform: Informatica's products run on Windows 95/NT and UNIX and support IBM DB 2, Informix, Oracle, Sybase, Microsoft SQL Server, IMS, VSAM, ODBC, flat file and other operational sources.

Power. Mart 장점 n n n 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.

n n n Executing and Maintaining automatically by Power. Mart’s 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

Power. Mart의 개선점 n n n Power. Mart 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 Power. Mart could improve its flexibility with global variables.

n n n Although Power. Mart 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.