8/14/2019 01 Introduction 1298

1/20

8/14/2019 01 Introduction 1298

2/20

About Informatica...

t Founded in 1993t Leader in enterprise solution products

t 300+ customerst Offices in major U.S. cities, London, Municht Worldwide distributorship

8/14/2019 01 Introduction 1298

3/20

About Informatica Resources...

t Trainingt Documentationt Webzinet Tech Supportt Professional Services

8/14/2019 01 Introduction 1298

4/20

Course Objectives

At the end of this course you should be able to:r Analyze sources and design target tablesr Build simple mappingsr Create and execute sessionsr Explain the server and memory processesr List the tuning variablesr Perform basic repository administration tasksr Describe the Informaticas enterprise solutionr Install and configure PowerMart / PowerCenter

8/14/2019 01 Introduction 1298

5/20

Course Prerequisites

To gain full benefit from this class, you shouldhave a strong working knowledge of:

r Relational database management systems

(RDBMS)r Structured Query Language (SQL)r Windows GUIr Open Database Connectivity (ODBC)

8/14/2019 01 Introduction 1298

6/20

About the Course Materials...

Lecture Binder t Sectioned by functional areat Review quiz with each sectiont Reference materials in back

Labs Binder t Hands-on lab exercisest Source table schema referencet Connectivity worksheet

8/14/2019 01 Introduction 1298

7/20

About the Classroom...

t Clientst Server(s)t Networkt Source, Target, Repositoryt Connectivity

8/14/2019 01 Introduction 1298

8/20

Data Warehousing

Data Warehouse

Extract

TransformLoad

Operational Sources

Metadata

End User Developer

8/14/2019 01 Introduction 1298

9/20

t Informatica Architecturet Design Processt Client Tool Review

r Repository Manager r Designer r Server Manager

Getting Started

8/14/2019 01 Introduction 1298

10/20

Designer Server Manager Repository Manager

Server

Repository

Informaticas Architecture

Targets 1-nSources 1-nPowerPlugs

Data Models

8/14/2019 01 Introduction 1298

11/20

t Network Protocolt Native Driverst ODBC

Connectivity Overview

Server

-

Target(s)

Designer

Repository Manager

Repository

Server Manager

Client

Network Protocol

O D B C

ODBC

Native/ODBC

Native

Native/ODBC

O D B C

Source(s)

8/14/2019 01 Introduction 1298

12/20

Informatica DesignProcess

5.

2.

3.

1.

Sessions

Source Def

Target Def

Mapping

4.

1. Create Repository2. Import Source Definitions3. Create Target Schema4. Create Mappings5. Load Data

8/14/2019 01 Introduction 1298

13/20

8/14/2019 01 Introduction 1298

14/20

Metadata Repository

u Information about the data mart systemu Catalogs the repositoryu Directs the server u Contains record of user accessu Can be sharedu Can be searched and reportedu Bridged through Metadata Exchange

8/14/2019 01 Introduction 1298

15/20

Repository Manager

Navigator Window

Output Window

Dependency Window

Analysis Window

8/14/2019 01 Introduction 1298

16/20

Security

Repository

Folder

Repository Privileges

Drilldown Access

Folder Permissions

User IDUser ID and password

Object Locking Object

8/14/2019 01 Introduction 1298

17/20

Folder Attributes

FOLDER OWNER - user who serves as focal point for folder permissions

PERMISSIONS - rights to read, write, and/or execute objects in a folder SHARED - property that allows you to make shortcuts to objects in a folder

SHORTCUT - a dynamic link to an object stored in a shared folder VERSIONS - folder iterations that indicate development stages

8/14/2019 01 Introduction 1298

18/20

Designer Workspace

Output Window

Workspace

Workbook Tabs

Navigator

Status Bar

Open Folder List

8/14/2019 01 Introduction 1298

19/20

Designer Options

Tablest columns viewedt column sizet object sizet object colors

Generalt workspace optionst reload objects on opent group source definitions

Formatt workspace colorst import keyst automatic Source

Qualifier creation

8/14/2019 01 Introduction 1298

20/20

Server Manager

Monitor Window

Navigator

Configure Window

OutputWindow