Informatica PowerCentre Online Training by Veera Deepika (English / Tamil)

Description

Informatica PowerCenter is an ETL (Enterprise Extract, Turn, and Load) tool used in the construction of data warehouses for businesses. ... The warehousing of data. Replication and synchronisation of results. Master Data Management (MDM) Integration Competency Centres (ICC)

Informatica is a company that provides ETL, data masking, data consistency, data replica, data virtualization, master data management , data integration products, etc. The most widely used data integration method for linking and gathering data from various data sources is Informatica ETL.

Training Outcome
  • Course Complete Certificate


Requirements
  • Knowledge of PL/SQL

Lessons

  • 20 Lessons
  • 35:00:00 Hours
  • • Data warehouse& its Architecture • OLTP & OLAP • Data mart • Top Down (Immon) Vs Bottom Up (Kimball) • ROLAP, MOLAP and HOLAP • Data Modeling & its types • Dimension Table & its types • Fact Table & its types • Schema & its types03:00:00
  • • What is ETL? • Different Informatica Products • Informatica PowerCenter Architecture • General flow of Informatica01:00:00
  • PowerCenter Client Tools : - (a) PowerCenter Repository Manager (b) PowerCenter Designer (c) PowerCenter Workflow Manager (d) PowerCenter Workflow Monitor01:00:00
  • • Creating a Repository • Working with Repository • Folders and Folder Permissions • Creating Folders02:00:00
  • • Working with Designer • Tools provided by Designer • Source & Target • Creating a simple Mapping • Transformations Overview02:00:00
  • • Source Qualifier Transformation • Aggregator Transformation • Expression Transformation • Filter Transformation02:00:00
  • • Joiner Transformation • Router Transformation • Update Strategy Transformation • Lookup Transformation02:00:00
  • • Normalizer Transformation • Sequence Generator Transformation • Rank Transformation02:00:00
  • • Workflows & Worklets • Sessions • Tasks01:00:00
  • • Parameters & Variables • Validation of Workflows01:00:00
  • Scheduling & Running Workflows01:00:00
  • • Workflow Monitor • Task View01:00:00
  • • Gantt Chart View • Example- How to monitor and view details01:00:00
  • (a) What is a Debugger? (b) Steps to use debugger in a mapping (c) Using breakpoint in debugger01:00:00
  • (a) Tracing in Informatica (b)How to set tracing level in a transformation01:00:00
  • • Properties of session • Treat Source Rows as Property • Commit Interval - Property • Session Log File Name & Session Log File directory • Enable Test Load • Memory Properties01:00:00
  • • Log options • Error Handling • Mapping and source/target Properties • Connection Properties in Mapping • Source Properties • Target Properties • Success or failure of session task01:00:00
  • • Transformation level Performance Tuning • Partitioning & its types • Parallel Processing & its types03:00:00
  • • SCD Type 1 • SCD Type 2 • SCD Type 3 • SCD Type 4 & 605:00:00
  • INFORMATICA INTERVIEW QUESTIONS 03:00:00

About instructor

Instructor
Name : Course Monkey
Reviews : 2 Reviews
Student : 1 Students
Courses : 114 Courses

Reviews

0
Based on 0 Reviews
1 Stars
2 Stars
3 Stars
4 Stars
5 Stars