Informatica PowerCenter Developer : Beginner to Expert Level

Informatica PowerCenter Developer : Beginner to Expert Level

Informatica developers analyze a business's database storage and warehousing capabilities and assess the company's data requirements.

Mapping in Informatica is a collection of source and target objects linked together by a set of transformations. These transformations consist of a set of rules, which define the data flow and how the data is loaded into the targets.

Data mapping is the process of extracting data fields from one or multiple source files and matching them to their related target fields in the destination. Data integration or ETL mapping helps consolidate data by extracting, transforming, and loading it to a data warehouse. The initial step of ETL is data mapping.

Our Informatica PowerCenter course provides 49 videos of lectures, which is sufficient to become expert in Informatica. For more knowledge you can refer our SQL level 1 and level 2 course.

1) Introduction of Informatica PowerCenter and Mappings

2) Filter Transformation

3) Expression Transformation

4) Joiner Transformation

5) Aggregator Transformation

6) Sorter Transformation

7) Sequence Generator

8) Rank Transformation

9) Router Transformation

10) Union Transformation

11) Source Qualifier

12) Normalizer Transformation

13) Look up Transformation

14) Update Strategy Transformation

15) Stored Procedure Transformation

16) Flat files

17) SCD

18) Parameters and Variables

19) XML

20) SQL Transformation

21) Debugger

22) Mapplet

23) UDF (User define function)

24) Task Commands

25) Reusable Transformation

26) Transaction Control

27) Version control

28) Shortcut folder / shared folder

29) Session Properties

30) how to create ODBC database connection

31) PMCMD command

Informatica Powercenter is an ETL tool which is used for Data integration.

Url: View Details

What you will learn

• Informatica, SQL

Rating: 3.85

Level: All Levels

Duration: 29 hours

Instructor: Rajnees Kumar