What you'll learn
Informatica, SQL
Requirements
Must have knowledge of SQL.
Description
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 Mappings2) Filter Transformation3) Expression Transformation4) Joiner Transformation5) Aggregator Transformation6) Sorter Transformation7) Sequence Generator8) Rank Transformation9) Router Transformation10) Union Transformation11) Source Qualifier12) Normalizer Transformation13) Look up Transformation14) Update Strategy Transformation15) Stored Procedure Transformation16) Flat files17) SCD 18) Parameters and Variables19) XML20) SQL Transformation21) Debugger 22) Mapplet23) UDF (User define function)24) Task Commands25) Reusable Transformation26) Transaction Control27) Version control28) Shortcut folder / shared folder29) Session Properties 30) how to create ODBC database connection31) PMCMD command
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Filter Transformation - 1
Lecture 3 Filter Transformation - 2
Lecture 4 Expression Transformation
Lecture 5 Joiner Transformation - 1
Lecture 6 Joiner Transformation - 2
Lecture 7 Aggregator Transformation
Lecture 8 Sorter Transformation
Lecture 9 Sequence Generator
Lecture 10 Rank Transformation
Lecture 11 Router
Lecture 12 Union Transformation - 1
Lecture 13 Union Transformation - 2
Lecture 14 Source Qualifier
Lecture 15 Normalizer - 1
Lecture 16 Normalizer - 2
Lecture 17 Look up Transformation - 1
Lecture 18 Look up Transformation - 2
Lecture 19 Look up Transformation - 3
Lecture 20 Look up Transformation - 4
Lecture 21 Look up Transformation - 5
Lecture 22 Update Strategy Transformation
Lecture 23 Stored Procedure Transformation
Lecture 24 Flat files - 1
Lecture 25 Flat files - 2
Lecture 26 SCD - 1
Lecture 27 SCD - 2
Lecture 28 SCD - 3
Lecture 29 SCD - 4
Lecture 30 SCD - 5
Lecture 31 SCD - 6
Lecture 32 Parameters and Variables
Lecture 33 XML
Lecture 34 SQL Transformation - 1
Lecture 35 SQL Transformation - 2
Lecture 36 SQL Transformation - 3
Lecture 37 Debugger
Lecture 38 Mapplet
Lecture 39 UDF (User define function)
Lecture 40 Task Commands - 1
Lecture 41 Task Commands - 2
Lecture 42 Reusable Transformation
Lecture 43 Transaction Control
Lecture 44 Version control
Lecture 45 Shortcut folder / shared folder
Lecture 46 Session Properties - 1
Lecture 47 Session Properties - 2
Lecture 48 how to create ODBC database connection
Lecture 49 PMCMD command
SQL developer, IICS developer, Informatica developer

Homepage

https://www.udemy.com/course/informatica-developer/