Informatica PowerCenter Training – Old 2
38 lessons0m total
Course content
IMPORTANT INSTRUCTIONS
1 lesson- Course Instruction
Lesson 01 to 10
10 lessons- S01 Introduction
- S02 Introduction To OracleSQL
- S03 SQL Commands
- S04 Introduction To ETL & Informatica
- S05 First Mapping In Informatica
- S06 Operators in Oracle, NULL
- S07 Filter TR, Order by in Oracle
- S08 Flat Files P1
- S09 Flat File P2
- S10 Router & Exp_TR
Lesson 11 to 20
10 lessons- S11 Expression & Group by
- S12 Group by And Aggregator TR
- S13 Aggregator Transformation
- S14 Constraints in Oracle SQL
- S15 Constraints & Joins in Oracle SQL
- S16 Joins in Oracle SQL
- S17 Source Qualifier TR
- S18 Joiner Transformation
- S19 Set Operators & Union TR
- S20 Union, Rank & SEQ Gen
Lesson 21 to 30
10 lessons- S21 Lookup Transformation
- S22 Lookup Continued & Staging Area
- S23 DWH Concepts Incremental Loading Mapping
- S24 Scd Type-1
- S25 Scd Type-2
- S26 Fact Load, Mini-Project
- S27 Project Explanation
- S28 Dev, Test & PROD, Unit Testing
- S29 Project Explanation & Re-Usable
- S30 Paramerization & Param Files in Informatica
Lesson 31 to 34
6 lessons- S31 Dynamic Lookup & Unconnected Lookup
- S32 Reusable Transformations, Maples & Worklets
- S33 Normalizer & Transaction Control Transformation
- S34 Event Wait, Event Raise, Assignment Task
- S35 Command Task, Email Task & Others
- S36 About Project, Fake Exp & Other Documents
Interview Preparation
1 lesson- Interview Preparation
₹15,000
One-time payment. Lifetime access.
- 38 on-demand lessons
- Lifetime access
- Certificate of completion