Informatica Online for Working professional by DATA VEDIC

INFORMATICA COURSE CONTENT

Session-1
Introduction to Data Ware House
Introduction to OLTP
Difference between OLTP and DWH
Dimension table
Fact table
Architecture of DWH
Star schema
Snowflake Schema
Data mart
Top down approch
Bottom up approch
ETL
Session-2
Types of ETL s
Code based
GUI based
Introduction to Informatica
Domain
service
Node
Informatica Power Center 9.1/9.5
Archtecture of Informatica
Repository
Repository service
Integration service
Informatica server component
Informatica client component
Session-3
Introduction to Admin tool
Introduction to client tools
Developer
Workflow manager
Workflow moniter
Repository Manager
Importing/creating source defenition
Importing/creating target defenition
creating Mapping
Creating session
creating workflow
Executing the Workflow
Monitoring the workflow
Understanding session log
Session-4
Working with Transformations ( Connected,unconnected,Active,Passive)
Expression
Filter
Sorter
Session-5
Aggregator
Rank
Seq generator
Router
Session-6
Union
Update Strategy(Options in session level)
Transaction control
Working with flat files
Normalizer
Session-7
Source qualifier
Joiner
Look up
Session-8
Stored Procedure
SQL Transformation
XML Source Qualifier
Session-9
Variable port in Expression
Working with variable port
Multiple pipe lines in mapping
Target load order
Debugger
File list
Constraint based loading

Session -10
SCD type -I
SCD type _II
SCD type -III
Session -11
Caches in loop up
Dynamic lookup
Persistent cache
Shared cache
named shared and un named shared cache
Parameters and parameter file

Session-12
variables
using variables
Performance tuning
Tasks
CMD task
email task
Session -13
Reusable transformation
Reusable Mapplet
Reusable session
Reusable Worklet
Link task
Parallel load
Sequential load
First load and incremental load

Session-14
Timer task
control task
event wait
event raise
decision task
Assignment task
Session -15
(use full in work environment)
Code movement from Dev to production
different methods for code movement
Deployment groups
Check in
check out
What is versioning
Find checkouts
dependencies
Comparing previous versions
Session-16
Partitions
Pass through
Round robin
Hash key
Hash user
Key range
DB
Session-17
Restartability
FAQ
Resume preparation