Informatica online training by RVH Technologies

1
(No Transcript)
2
(No Transcript)
3
Introduction to Informatica From RVH
Technologies
4
Data Warehousing

• Data warehousing is the entire process of data
  extraction, transformation, and loading of data
  to the warehouse and the access of the data by
  end users and applications

5
Data Mart

• A data mart stores data for a limited number of
  subject areas, such as marketing and sales data.
  It is used to support specific applications.
• An independent data mart is created directly from
  source systems.
• A dependent data mart is populated from a data
  warehouse.

6
(No Transcript)
7
Components Of Informatica

• Repository Manager
• Designer
• Workflow Manager

8
Informatica provides the following integrated
components

• Informatica repository. The Informatica
  repository is at the center of the Informatica
  suite. You create a set of metadata tables within
  the repository database that the Informatica
  applications and tools access. The Informatica
  Client and Server access the repository to save
  and retrieve metadata.
• Informatica Client. Use the Informatica Client to
  manage users, define sources and targets, build
  mappings and mapplets with the transformation
  logic, and create sessions to run the mapping
  logic. The Informatica Client has three client
  applications Repository Manager, Designer, and
  Workflow Manager.
• Informatica Server. The Informatica Server
  extracts the source data, performs the data
  transformation, and loads the transformed data
  into the targets.

9
Architecture
10
Sources

• Power Mart and Power Center access the following
  sources
• Relational. Oracle, Sybase, Informix, IBM DB2,
  Microsoft SQL Server, and Teradata.
• File. Fixed and delimited flat file, COBOL file,
  and XML.
• Extended. If you use Power Center, you can
  purchase additional Power Connect products to
  access business sources such as PeopleSoft, SAP
  R/3, Siebel, and IBM MQSeries.
• Mainframe. If you use Power Center, you can
  purchase Power Connect for IBM DB2 for faster
  access to IBM DB2 on MVS.
• Other. Microsoft Excel and Access.

11
Targets

• Power Mart and Power Center can load data into
  the following targets
• Relational. Oracle, Sybase, Sybase IQ, Informix,
  IBM DB2, Microsoft SQL Server, and Teradata.
• File. Fixed and delimited flat files and XML.
• Extended. If you use Power Center, you can
  purchase an integration server to load data into
  SAP BW. You can also purchase Power Connect for
  IBM MQSeries to load data into IBM MQSeries
  message queues.
• Other. Microsoft Access.
• You can load data into targets using ODBC or
  native drivers, FTP, or external loaders.

12
General Flow of Informatica

• Step 1 Creating Repository ,creating folders
  ,Creating users and assign permission in
  Repository Manager, so as to work in the client
  tools.
• Step 2Connecting to the repository from the
  designer. importing source and target tables ,
  creation of mappings.
• Step 3 Creation of Workflow through workflow
  Manager which has different tasks connected
  between them. In that ,session is the task which
  is pointing to a mapping created in the designer.

13
Repository Architecture

Repository Client
Repository Server
---------------------------- Repository Agent
Repository Database
14
Working with Repository..

• By default 2 users will be created in the
  repository .
• Database user used to connect to the repository.
• Administrator User.
• By default 2 Groups will be created
• Public
• Administrators.
• These groups and users cannot be deleted from the
  repository . The administrator group has only
  read privilege for other user groups.

15
Other Features of Repository Manager

• Viewing , removing Locks
• Adding Repository
• Backup and Recovery of Repository
• Taking Metadata reports like Completed Sessions
  details , List of reports on Jobs , session ,
  workflow etc

16
Working with Designer

• Connecting to the repository using User id and
  password.
• Accessing the folder
• Importing the source and target tables required
  for mapping.
• Creation of mapping

17
Tools provided by Designer

• Source Analyzer Importing Source definitions for
  Flat file, XML, COBOL and relational Sources.
• Warehouse Designer Use to Import or create
  target definitions.
• Transformation Developer Used to create reusable
  transformations
• Mapplet Designer Used to create mapplets
• Mapping Designer Used to create mappings

18
Importing Sources
19
Import from Database

• Use ODBC connection for importing from database

20
Import from File
21
Creating Targets

• You can create target definitions in the
  Warehouse Designer for file and relational
  sources. Create definitions in the following
  ways
• Import the definition for an existing target.
  Import the target definition from a relational
  target.
• Create a target definition based on a source
  definition. Drag one of the following existing
  source definitions into the Warehouse Designer to
  make a target definition
• Relational source definition
• Flat file source definition
• COBOL source definition
• Manually create a target definition. Create and
  design a target definition in the Warehouse
  Designer.

22
Mapping creation Contd..

• The source definition appears in the workspace.
  The Designer automatically connects a Source
  Qualifier transformation to the source
  definition. After you add the target definition,
  you connect the Source Qualifier to the target.
• Click the Targets icon in the Navigator to open
  the list of all target definitions.
• Click and drag the icon for the T_EMPLOYEES
  target into the workspace.
• The target definition appears. The final step is
  connecting the Source Qualifier to this target
  definition.

23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)