Title: Informatica Online training India hyderabad|Informatica training for Low cost-price
1(No Transcript)
2(No Transcript)
3Introduction to Informatica From RVH
Technologies
4Data 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
5Data 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)
7Components Of Informatica
- Repository Manager
- Designer
- Workflow Manager
8Informatica 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.
9Architecture
10Sources
- 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.
11Targets
- 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.
12General 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.
13Repository Architecture
Repository Client
Repository Server
---------------------------- Repository Agent
Repository Database
14Working 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.
15Other 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
16Working 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
17Tools 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
18Importing Sources
19Import from Database
- Use ODBC connection for importing from database
20Import from File
21Creating 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.
22Mapping 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)