|
Informatica_PC_course_content_2023
|
|
|
Oracle SQL for Beginners | SQL Complete Tutorial for Beginners | SQL Full Course | SQL Tutorial
(758:00)
|
|
|
Session 1 Introduction to Data warehouse
(63:00)
|
|
|
|
Day 1 - Business Intelligence and Data warehouse
|
|
|
Session 2 Data warehouse - part-2
(77:00)
|
|
|
|
Day 2 - Data Modelling
|
|
|
Session 3 Informatica Architecture
(76:00)
|
|
|
|
Day 3 - Informatica Architecture
|
|
|
Informatica Installation 10.4 on Windows | How to install Informatica PowerCenter 10.4 on Windows
(38:00)
|
|
|
Session 4 Informatica client tool-First Mapping
(66:00)
|
|
|
|
Day 4 - Informatica Client component
|
|
|
Session 5 File to Table load
(59:00)
|
|
|
|
Day 5 - Flat File to Table load
|
|
|
|
Flat file exercises
|
|
|
Session 6 Table to File load
(72:00)
|
|
|
|
Day 6 - Oracle table to File Load
|
|
|
Session 7 Indirect File loading
(61:00)
|
|
|
|
Day 7 - Indirect File loading
|
|
|
|
Flat file exercises
|
|
|
Session 8 Source Qualifier Transformation
(68:00)
|
|
|
|
Day 8 - Source Qualifier Transformation
|
|
|
|
Source Qualifier exercise
|
|
|
Session 9 Filter and Expression Transformation
(52:00)
|
|
|
|
Day 9 - Filter and Expression Transformation
|
|
|
|
Filter Transformation Exercise
|
|
|
|
Expression Tranformation Exercise
|
|
|
Session 10 Joiner, sorter Transformation
(49:00)
|
|
|
|
Day 10 - Joiner and Sorter Tansformation
|
|
|
|
Joiner Transformation Exercise
|
|
|
|
Sorter Transformation Exercise
|
|
|
Session 11 Aggregator Transformation
(60:00)
|
|
|
|
Day 11 - Aggregator Transformation
|
|
|
|
Aggregator Tranformation Exercise
|
|
|
Session 12 Router and Rank Transformation
(56:00)
|
|
|
|
Day 12 - Router and Rank Transformation
|
|
|
|
Router Tranformation Exercise
|
|
|
|
Rank Tranformation Exercise
|
|
|
Session 13-Sequence Generator, Union Transformation
(50:00)
|
|
|
|
Day 13 - Sequence and Union Transformation
|
|
|
|
Sequence Generator Exercise
|
|
|
Session 14-Lookup Transformation part 1
(58:00)
|
|
|
|
Day 14 - Conencted Lookup Transformation
|
|
|
|
Lookup Transformation Exercise
|
|
|
Session 15-Lookup Transformation part 2
(54:00)
|
|
|
|
Day 15 - Lookup policy and Lookup Cache
|
|
|
|
Unconnected Lookup Queries
|
|
|
|
Lookup Transformation Exercise
|
|
|
Session 16-Update strategy - SCD type 1
(37:00)
|
|
|
|
Day 16 - Update strategy transformation
|
|
|
|
Update Strategy Exercise
|
|
|
Session 17-Normalizer, Transaction control
(68:00)
|
|
|
|
Day 17 - Normalizer and Transaction Control Transformation
|
|
|
|
Normalizer Exercise
|
|
|
|
Transaction Control Exercise
|
|
|
Session 18 - SQL, SP, Java Transformation
(57:00)
|
|
|
|
Day 18 - SQL, Stored Procedure, Java Transformation
|
|
|
Session 19 - SCD - Slowly Changing Dimension
(50:00)
|
|
|
|
Day 19 - SCD Types
|
|
|
Session 20 - Debugger, reusable trans, mapplet, parameter
(62:00)
|
|
|
|
Day 20 - Reusable transformation Mapplet Debugger
|
|
|
Session 21 - parameter and variable, workflow level task
(61:00)
|
|
|
|
Day 21 - Parameter and Variable
|
|
|
|
Day 22 - Workflow level task
|
|
|
Session 22 - Workflow level properties - Part 2
(65:00)
|
|
|
|
Day 22 - Workflow level task
|
|
|
Session 23 - Performance Tuning, Lookup Cache
(67:00)
|
|
|
|
Day 23 - Performance Tuning
|
|
|
Session 24 - Mapping level properties
(54:00)
|
|
|
Session 25 - Wf Properties, Deployment, checkin-out
(67:00)
|
|
|
Session 26 - Roles and Resposibility, Project explanation
(63:00)
|
|
|
|
Day 26 - Sample Project explanation
|
|
|
Session 27 Agile Project explanation, project architecture
(53:00)
|
|
|
|
Day 27 - Agile Project team
|
|
|
Session 28 Scheduler, complex scenario
(70:00)
|
|
|
|
Day 28 - Scheduler and Complex scenarios
|
|
|
Session 29 - CDC and variables, check-in check-out
(56:00)
|
|
|
Session 31 - Informatica Production support roles and responsibilities
(84:00)
|
|
|
|
Day 31 -Production support
|
|
|
Informatica PowerCenter Resumes
|
|
|
Informatica Scenario Based Interview Questions
|
|
|
|
Unix Notes-20231031T130308Z-001
|
|
Launch your Graphy