Informatica Training Course
Quontra Solutions is leading provider of IT career advice, Training and consulting services for IT Professional and corporates across USA. We train individuals or Corporate via online or class Room training in all IT tools and Technologies.
Course Content
1.Basics of Data warehousing concepts
- a)Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
- b)Slowly Changing Dimensions (SCD1, SCD2, SCD3)
- c)Metadata
- d)Dimensional Table
- e)Types Of Dim Tables
- f)Fact Table
- g)Types of Fact Tables
- h)OLTP (OnLine Transaction Processing)
- i)OLAP (Online Analysis And Processing)
- j)OLTP Vs OLAP
- k)Advantages of OLAP
- l)Different Methodologies of DWH
2. Power Center Components
- a)Designer
- b)Repository Manager
- c)Workflow Manager
- d)Workflow Monitor
3.Informatica Concepts and Overview
- a)Infomatica Architecture.
- b)Source Qualifier
- c)Target Designer
- d)Transformations
- e)Mappings
- f)Mapplets
- g)Sessions
- h)Tasks
4.Sources
- a)Working with relational Sources
- b)Working with Flat Files
5.Targets
- a)Working with Relational Targets
- b)Working with Flat file Targets
6.Transformations
- a)Expression Transformation
- b)Lookup Transformation
- c)Sequence Generator Transformation
- d)Filter Transformation
- e)Joiner Transformation
- f)Sorter Transformation
- g)Procedural Transformation
- h)Router Transformation
- i)Aggregator Transformation
- j)Update Strategy Transformation
- k)Union Transformation
- L)Rank Transformation
- M)Transaction Control Transformation
- N)Normalizer Transformation
- O)Source Qualifier Transformation
- P)Stored Procedure Transformation
- Q)XML Source Qualifier Transformation
- R)Debugging Mappings
7.TYPES Of LookUp Caches.
- a)Static LookUp Cache
- b)Dynamic LookUp Cache
- c)Perisistance lookup Cache
- d) Shared LookUp Cache
8.Task Types:
- a)Session
- b)Command
- c)EMAIL
- d)Timer
- e)Event Wait
- f)Event Raise
- g)Decision
- h)Assignment
- i)Control
- j)Worklet
9.ADVANCED INFORMATICA CONCEPTS
- a)Unconnected lookup Transformation
- b)Mapplet a
- d)Defining Reusable Transformations.
- e)Tasks And Types of Tasks.
- f)Worklet
- g)Scheduling Work flow
- h)Target Load Plan
- i)Types of Batch Processing
- j)Link conditions
- k)Mapping Parameters
- m)Mapping Variables
- n)Defining Session Parameters
- o)SCD Type I, II, III Implementation.
- p)PMCMD Utility
10. Informatica Coding Standards & Best Practices used in real time development.
QUONTRA SOLUTIONS
Contact 404 900 9988
Contact 404 900 9988
