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
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.
View Sitemap