Course Content

INFORMATICA

1. RDBMS Concepts
2. Introduction to SQL
3.Data Manipulation Language (DML)
   INSERT
 UPDATE
 DELETE
4.Data Definition Language(DDL)
 CREATE
 ALTER
 DROP
5.Data Query Language(DQL)
 SELECT
6. JOINS
 NORMAL JOIN
 LEFT OUTER JOIN
 RIGHT OUTER JOIN
 FULL OUTER JOIN
 CROSS JOIN
7. SET OPERATORS
 UNION
 UNION ALL
 INTERSECT
 MINUS
8. INDEXES
 BIT MAP
 B TREE
 FUNCTION BASED
 UNIQUE

9.ETL Terminology
 Need of ETL
 What are ETL tools?
 Role of ETL in DWH
10. ETL Architecture
 Source Extraction
 Data Transformation Logic
 Data Loading
11. Transformation Operations
 The understanding of basic operation of Transformation Logic
 Data Type Conversion Operation
 Filtering
 Sorting
 Routing
 Ranking
 Calculation operation
 Sequence Generation
 Lookup operation, etc.
12. Architecture
 Server Components
 Repository Server
 Informatica Server
 Client Tools
 Repository Manager
 Designer
 Workflow Manager
 Workflow Monitor
13. Designer
• Components of Designer tool
 Source Analyzer
 Target Designer
 Mapping Designer
 Transformation developer
 Mapplet Designer
 Working with Database Sources
 Working with Flat Files
 Working with Targets
 Mappings
 Mapplets
 Mapping Parameters and Variables
 User-Defined Functions
 Debugger
14. Transformations
 Creating a Transformation
 Configuring a Transformation
 Working with Ports
 Working with Expressions
15. List of Transformations
 Aggregator
 Expression
 Source qualifier
 Rank
 Filter
 Router
 Stored Procedure
 Transaction control
 Normalizer
 Sequence generator
 Union
 Joiner
 XML Source qualifier
 Sorter
 Lookup
 Update Strategy
16. Workflow Basics
 Workflow Manager Options
 Workflows and Worklets
 Creating a Workflow
 Workflow Wizard
 Assigning an Integration Service
 Working with Worklets
 Working with Links
 Sessions
 Tasks
 Creating Task
 Configuring Task
 Command Task
 Control Task
 Event Task
 Timer Task
17. Sources
 Overview
 Configuring Sources in Sessions
 Working with Relational Sources
 Working with File Sources
18. Targets
 Overview
 Configuring Targets in Sessions
 Working with Relational Targets
 Working with File Targets
 Reject Files
19. Validation
 Validating Tasks
 Validating Workflows
 Validating Worklets
 Validating Sessions
20. Scheduling and Running Workflows
 Manually Starting a Workflow
 Scheduling Workflow
21. Email
 Overview
 Working with Email Task
 Configuring Email on UNIX
22. Workflow Monitor
 Overview
 Using the Workflow Monitor
 Working with Tasks and Workflows
 Using Gantt Chart View
 Using the Task View
 Workflow Monitor Details
 Integration Service properties
 Workflow & Worklet Run Properties

23. Session and Workflow Logs
 Log Events
 Working with Log Files
 Workflow Logs
 Session Logs
24. Command Reference
• Using Command Line Programs
 Infacmd
 Infasetup
 Pmcmd
 Pmrep
25. Transformation Language Reference
 The Transformation Language
 Constants
 Operators
 Variables
 Dates
 Functions
26. Performance Tuning
 What is Performance Tuning?
 Key Levels for Performance Tuning
 Performance Tuning Overview
 Scope for Performance at Mapping Level
27. Introduction to IDQ
 Developer Profiling
 Data Standardization
 Address Validation
 Matching
 Labeling and Parsing the data
28. Introduction to MDM
 Master Data
 Master Data Management
 A Reliable Foundation Of Master Reference Data
 Components of MDM Hub
 Application Server Tier
 Database Server Tier
 Batch Data Process Flow
 Trust Framework
 Consolidation Flag

29.Defining Data Model
 Data Mode Elements
 Data Model
 Relationships
 Relationship Types
 Lookups
 Global Business Identifier (GB I D) Flag
 Configuring Stage and Load process
 Configuring Merge Process
 Batch process
 Data Management Tools
 User exits and Log Files