Informatica Training And Placement - Online And Classroom Trainings

[sravaniravi]

9startek is offering Informatica Training.

 

Informatica Power Center 7.x/8.x/9.x

  Introduction to ETL Logic

  Overview of Staging Area

  Need of ETL Logic

  Difference between OLTP systems and OLAP systems

  Construction of DWH/Datamarts using ETL logic

  Introduction to Informatica Power Center

  Overview of sub tools of the Informatica Power Center:

·               Informatica Client

·               Informatica Server

·               Informatica Repository

·               Informatica Repository server

·               Internal Architecture of the server

  Informatica client:

·               Informatica designer

·               Workflow manager

·               Workflow monitor

·               Repository manager

·               Repository server administrative console

  Informatica Designer:

·               Source analyzer

·               Ware house designer/ target designer

·               Transformation developer

·               Mapplet designer

·               Mapping designer

  Workflow manager:

·               Workflow designer

·               Worklett designer

·               Task developer

  Transformations:

·               Reusable transformations

·               Non-reusable transformations

Active and Passive transformations

1)              Source qualifier

2)              Expression

3)              Aggregator

4)              Rank

5)              Filter

6)              Router

7)              Lookup

a)              Connected

B)              Unconnected

 

  Advanced Transformations:

Java Transformation

Sql  Transformation

HTTP transformation

SAP R/3 Transformations

Mapping designer:

  Best practices when building mappings

  Construction of simple mappings for dimension tables and fact tables

  Dimension mappings:

·               SCD type-1

·               SCD type-2

·               Flag current data

·               Effective data range

·               Version number mapping

·               SCD type-3

·               Construction of the complex mappings for Data warehousing

·               Creation of the cubes

·               Analysis of Business user requirements

Development of the target tables from business user requirements

  Source analyzer:

·               Import source tables from different data bases or flat files

·               Create source tables in source analyzer itself.

·               Target designer:

·               Import target tables from different data bases or flat files

·               Create target tables in target designer itself.

·               Reusable transformations in Transformation developer

·               Transformation logic development in Mapplet designer

·               Properties explanation of the transformations

·               Customised query generation in source qualifier

·               Pre and post sql

  Differences between source qualifier and joiner transformation with practical explanation

  Difference between filter and router transformations with practical explanation

  Difference between expression and aggregator transformation with practical explanation

  Overview of the workflow manager

·               Reusable tasks development in task developer

·               Tasks logic development in worklett designer

·               Workflow development in workflow designer

  Explanation of the different types of the memories

  Overview of the load manager

  Overview of the Data transformation manager

  Overview of different types of tasks:

·               Start task

·               Session task

·               Event wait

·               Event raise

·               Timer

·               Decision task

·               Control task

·               E-mail task

·               Command task

·               Scheduling a task

·               Mapping parameters and variables creation

·               Parameter file creation

·               Internal working function of the Informatica Power center

·               Parallel Pipeline partitioning

·               Creation and deletion of portioning points

  Execution of the mappings:

·               Normal execution

·               Debugging mode execution

  Loading:

·               Normal loading

·               Bulk loading

·               Constraint based loading

  Lookup cache:

·               Static

·               Dynamic

·               Recache from source

·               Persistent cache

·               Shared cache

  Analysis of BRS

  Development of RRS

Sample project development

 

Course provided by well experienced faculty.

 

Please contact us at

Phone: 214-501-8177

Email:[email protected]