| Description of Informatica Tutorial Detail Description:- Introduction to Data Warehousing Understanding the scope of Data warehouse project Data warehouse Architecture and Design Informatica and Data warehousing Informatica Architecture Informatica Server ETL with Informatica Informatica Suite Components Informatica Designer Workflow Monitor Source Analyzer Warehouse Designer Mapping Designer Mapplets Designer Transformations in Informatica Importing sources and Targets Source Qualifier Transformation · Filter Transformation · Expression Transformation · Aggregator Expression · Router Transformation · Lookup Transformation · Rank Transformation · Sequence Generator · XML Transformation (Generator Parser, both) · Pushdown Optimization · HTTP Transformation · Java Transformation · New Functions in version 8.6 · Creating, Configuring and Linking Ports · Joiner Transformation · Sorter Transformation · Using Informatica Manager Creating Repository · Managing the Repository · ODBC DSN creation · Designing the ETL · Understanding The After-Design Scenario · Specifying the Database Connections · Advanced Informatica · Repository Security · Managing Groups · Managing Users · Managing Privileges · Changing password · Folder Permission Backup · Restore · Troubleshooting Informatica · Understanding Jobs and Scheduler Informatica Software Architecture illustrated: Informatica ETL product, known as Informatica Power Center consists of 3 main components. 1. Informatica PowerCenter Client Tools: These are the development tools installed at developer end. These tools enable a developer to Define transformation process, known as mapping. (Designer) Define run-time properties for a mapping, known as sessions (Workflow Manager) Monitor execution of sessions (Workflow Monitor) Manage repository, useful for administrators (Repository Manager) Report Metadata (Metadata Reporter) 2. Informatica PowerCenter Repository: Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica. 3. Informatica PowerCenter Server: Server is the place, where all the executions take place. Server makes physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system. This architecture is visually explained in diagram below: Sources Standard: RDBMS, Flat Files, XML, ODBC Applications: SAP R/3, SAP BW, PeopleSoft, Siebel, JD Edwards, i2 EAI: MQ Series, Tibco, JMS, Web Services Legacy: Mainframes (DB2, VSAM, IMS, IDMS, Adabas)AS400 (DB2, Flat File) Remote Sources Informatica Client Tools, Power Center Repository, Power Center Server Targets Standard: RDBMS, Flat Files, XML, ODBC Applications: SAP R/3, SAP BW, PeopleSoft, Siebel, JD Edwards, i2 EAI: MQ Series, Tibco, JMS, Web Services Legacy: Mainframes (DB2)AS400 (DB2) Remote Targets This is the sufficient knowledge to start with Informatica. So lets go straight to development in Informatica.
|
Informatica
Subscribe to:
Posts (Atom)