Last updated 5/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 13.02 GB | Duration: 29h 6m

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

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, transfog, 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:

gfxtra__Informatic.part01.rar.html

gfxtra__Informatic.part02.rar.html

gfxtra__Informatic.part03.rar.html

gfxtra__Informatic.part04.rar.html

gfxtra__Informatic.part05.rar.html

gfxtra__Informatic.part06.rar.html

gfxtra__Informatic.part07.rar.html

gfxtra__Informatic.part08.rar.html

gfxtra__Informatic.part09.rar.html

gfxtra__Informatic.part10.rar.html

gfxtra__Informatic.part11.rar.html

gfxtra__Informatic.part12.rar.html

gfxtra__Informatic.part13.rar.html

gfxtra__Informatic.part14.rar.html