powercenter basics in Informatica - Quontra Solutions

Information about powercenter basics in Informatica - Quontra Solutions

Published on September 16, 2014

Author: quontra123

Source: authorstream.com


Informatica PowerMart / Power Center Basics: Informatica PowerMart / Power Center Basics  Informatica Corporation, 2003. All rights reserved. Course Objectives: At the end of this course you will: Understand how to use all major Power Center components Be able to perform basic Repository administration tasks Be able to build basic ETL Mappings and Mapplets Be able to create, run and monitor Workflows Understand available options for loading target data Be able to troubleshoot most problems Course Objectives Extract, Transform, and Load: Extract, Transform, and Load RDBMS Mainframe Other Operational Systems Data Warehouse Decision Support Transaction level data Optimized for Transaction Response Time Current Normalized or De- Normalized data Aggregated data Historical ETL Extract Load Transform Aggregate Data Cleanse Data Consolidate Data Apply Business Rules De-normalize PowerPoint Presentation: PowerCenter Architecture PowerCenter 7 Architecture: PowerCenter 7 Architecture Not Shown: Client ODBC Connections for Source and Target metadata Targets Sources native native TCP/IP Heterogeneous Targets Repository Repository Server Repository Agent TCP/IP native Server Heterogeneous Targets Repository Designer Workflow Workflow Rep Server Manager Manager Monitor Administrative Console PowerCenter 7 Components: PowerCenter Repository PowerCenter Repository Server PowerCenter Client Designer Repository Manager Repository Server Administration Console Workflow Manager Workflow Monitor PowerCenter Server External Components Sources Targets PowerCenter 7 Components Repository Topics: Repository Topics By the end of this section you will be familiar with: The purpose of the Repository Server and Agent The Repository Server Administration Console GUI interface The Repository Manager GUI interface Repository maintenance operations Security and privileges Object sharing, searching and locking Metadata Extensions Repository Server: Each Repository has an independent architecture for the management of the physical Repository tables Components: one Repository Server, and a Repository Agent for each Repository Repository Server Client overhead for Repository management is greatly reduced by the Repository Server Repository Repository Server Repository Agent Server Repository Manager Repository Server Administration Console Repository Server Features: Manages connections to the Repository from client applications Can manage multiple Repositories on different machines on a network Uses one Repository Agent process to insert, update and fetch objects from the Repository database tables, for each Repository it manages Maintains object consistency by controlling object locking Repository Server Features The Repository Server runs on the same system running the Repository Agent Repository Server Administration Console: Use Repository Administration console to Administer Repository Servers and Repositories through Repository Server. Following tasks can be performed: Add, Edit and Remove Repository Configurations Export and Import Repository Configurations Create a Repository Promote a local Repository to a Global Repository Copy a Repository Delete a Repository from the Database Backup and Restore a Repository Start, Stop, enable and Disable a Repositories View Repository connections and locks Close Repository connections. Upgrade a Repository Repository Server Administration Console Repository Server Administration Console: Repository Server Administration Console Information Nodes Console Tree HTML View Hypertext Links to Repository Maintenance Tasks Repository Management: Repository Management Perform all Repository maintenance tasks through Repository Server from the Repository Server Administration Console Create the Repository Configuration Select Repository Configuration and perform maintenance tasks: Create Delete Backup Copy from Disable Export Connection Make Global Notify Users Propagate Register Restore Un-Register Upgrade Repository Manager: Use Repository manager to navigate through multiple folders and repositories. Perform following tasks: Manage the Repository Launch Repository Server Administration Console for this purpose Implement Repository Security Managing Users and Users Groups Perform folder functions Create, Edit, Copy and Delete folders View Metadata Analyze Source, Target, Mappings and Shortcut dependencies . Repository Manager Repository Manager Interface: Repository Manager Interface Navigator Window Main Window Dependency Window Output Window Users, Groups and Repository Privileges: Users, Groups and Repository Privileges Steps: Create groups Create users Assign users to groups Assign privileges to groups Assign additional privileges to users (optional) Managing Privileges: Managing Privileges Check box assignment of privileges Folder Permissions: Folder Permissions Assign one user as the folder owner for first tier permissions Select one of the owner’s groups for second tier permissions All users and groups in the Repository will be assigned the third tier permissions Object Locking: Object Locking Object Locks preserve Repository integrity Use the Edit menu for Viewing Locks and Unlocking Objects Object Searching (Menu- Analyze – Search): Object Searching (Menu- Analyze – Search) Keyword search Limited to keywords previously defined in the Repository (via Warehouse Designer) Search all Filter and search objects Object Sharing: Object Sharing Reuse existing objects Enforces consistency Decreases development time Share objects by using copies and shortcuts Required security settings for sharing objects : Repository Privilege: Use Designer Originating Folder Permission: Read Destination Folder Permissions: Read/Write COPY SHORTCUT Copy object to another folder Link to an object in another folder Changes to original object not captured Dynamically reflects changes to original object Duplicates space Preserves space Copy from shared or unshared folder Created from a shared folder Adding Metadata Extensions: Allows developers and partners to extend the metadata stored in the Repository Accommodates the following metadata types: Vendor-defined - Third-party application vendor-created metadata lists For example, Applications such as Ariba or PowerConnect for Siebel can add information such as contacts, version, etc. User-defined - PowerCenter/PowerMart users can define and create their own metadata Must have Administrator Repository or Super User Repository privileges Adding Metadata Extensions Sample Metadata Extensions: Sample Metadata Extensions Sample User Defined Metadata, e.g. - contact information, business user Reusable Metadata Extensions can also be created in the Repository Manager Design Process: Design Process Create Source definition(s) Create Target definition(s) Create a Mapping Create a Session Task Create a Workflow from Task components Run the Workflow Monitor the Workflow and verify the results Source Object Definitions : By the end of this section you will: Be familiar with the Designer GUI interface Be familiar with Source Types Be able to create Source Definitions Understand Source Definition properties Be able to use the Data Preview option Source Object Definitions Source Analyzer: Source Analyzer Analyzer Window Navigation Window Designer Tools Methods of Analyzing Sources: Import from Database Import from File Import from Cobol File Import from XML file Create manually Methods of Analyzing Sources Repository Relational Flat file COBOL file XML file Source Analyzer PowerPoint Presentation: Analyzing Relational Sources Table View Synonym Relational Source DEF Source Analyzer Repository Repository Server Repository Agent TCP/IP native DEF ODBC Analyzing Relational Sources: Analyzing Relational Sources Editing Source Definition Properties PowerPoint Presentation: Analyzing Flat File Sources Mapped Drive NFS Mount Local Directory DEF Fixed Width or Delimited Flat File Source Analyzer Repository Repository Server Repository Agent TCP/IP native DEF PowerPoint Presentation: Flat File Wizard Three-step wizard Columns can be renamed within wizard Text, Numeric and Datetime datatypes are supported Wizard ‘guesses’ datatype XML Source Analysis: XML Source Analysis Mapped Drive NFS Mounting Local Directory In addition to the DTD file, an XML Schema or XML file can be used as a Source Definition DEF .DTD File DATA Source Analyzer Repository Repository Server Repository Agent TCP/IP native DEF PowerPoint Presentation: Analyzing VSAM Sources Supported Numeric Storage Options: COMP, COMP-3, COMP-6 Mapped Drive NFS Mounting Local Directory DEF .CBL File DATA Source Analyzer Repository Repository Server Repository Agent TCP/IP native DEF PowerPoint Presentation: VSAM Source Properties Target Object Definitions : By the end of this section you will: Be familiar with Target Definition types Know the supported methods of creating Target Definitions Understand individual Target Definition properties Target Object Definitions Creating Target Definitions: Methods of creating Target Definitions Import from Database Import from an XML file Manual Creation Automatic Creation Creating Target Definitions Automatic Target Creation: Automatic Target Creation Drag-and-drop a Source Definition into the Warehouse Designer Workspace Import Definition from Database: Can “ Reverse engineer” existing object definitions from a database system catalog or data dictionary Import Definition from Database Table View Synonym Warehouse Designer Database DEF Repository Repository Server Repository Agent TCP/IP native DEF ODBC Manual Target Creation: 2. Add desired columns ALT-F can also be used to create a new column Manual Target Creation 1 . Create empty definition 3. Finished target definition Target Definition Properties: Target Definition Properties Target Definition Properties: Target Definition Properties Creating Physical Tables: Creating Physical Tables LOGICAL Repository target table definitions PHYSICAL Target database tables DEF DEF DEF Execute SQL via Designer PowerPoint Presentation: Create tables that do not already exist in target database Connect - connect to the target database Generate SQL file - create DDL in a script file Edit SQL file - modify DDL script as needed Execute SQL file - create physical tables in target database Use Preview Data to verify the results (right mouse click on object) Creating Physical Tables Thank you: Thank you

Related presentations

Other presentations created by quontra123