• support@conveytechlabs.com

online_training

$400.00

Categories: ,

Course Description

Informatica has several products focused on data integration. However, Informatica PowerCenter is the flagship product in the portfolio. It has become so popular that Informatica PowerCenter has now become synonymous to Informatica. So whenever I use Informatica in the blog now, it essentially means Informatica PowerCenter. Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organizations including telecommunication, health care, financial and insurance services.

Course Information

  • Duration: 30 hrs
  • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
  • Method: Online/Classroom Training
  • Study Material: Soft Copy

Course Content

Introduction to Dataware Housing

Data warehouse concept Differences between Online Transaction Processing and data warehouse Types of Data Warehouse Data warehouse Architecture Difference between Data warehouse & Data mart Data Warehouse Approaches Data Warehouse Components Logical & physical Design Operational data sources(ODS)

MODELING FOR DATA WAREHOUSE

Fact Table Dimension tables and types Data Warehouse Schemas: Star schema and Star Query, star flake schema, snowflake schema and Galaxy Schema

Informatica PowerCenter

Product Overview PowerCenter Domain Administration Console PowerCenter Repository PowerCenter Client Repository Service Integration Service

REPOSITORY MANAGER

Adding a Repository to the Navigator Configuring a Domain Connection Connecting to a Repository Viewing Object Dependencies Validating Multiple Objects Comparing Repository Objects Working with FoldersAgenda(Continue..)

POWERCENTER DESIGNER

Source Analyzer Working with Relational Sources Working with Flat Files Target Designer Mappings Transformations Working with Ports Using Default Values for Ports User-Defined Default Values Tracing Levels Basic First Mapping Expression Transformation Filter Transformation Router Transformation Union Transformation Sorter Transformation Rank Transformation Aggregator Transformation Joiner Transformation Source Qualifier Lookup Transformation Lookup Types Lookup Transformation Components Connected Lookup Transformation Unconnected Lookup Transformation Lookup Cache Types: Dynamic, Static, Persistent, Shared Update Strategy Dynamic Lookup Cache Use Lookup Query Lookup and Update Strategy Examples Stored Procedure Transformation Connected Stored Procedure Transformation Unconnected Stored Procedure Transformation Sequence Generator Transformation SCD Type 1 and Type 2 with real time examples Mapplets: Mapplet Input and Mapplet Output Transformations Normalizer Transformation XML Sources Import and usage Mapping Parameters and Variables Parameter File Indirect Flat File Loading

WORKFLOW MANAGER

Working with Workflows Assigning an Integration Service Working with Links Workflow Variables Session Parameters Working with Tasks Session Task Command Task Working with Event Tasks Email task Decision Task Control Task Timer task Assignment Task Session Properties Workflow Properties

ADVANCED TOPICS

Push down Optimization Technique Version Control Constraint Based Load Ordering Target Load Plan Order

Key Features

  • Career oriented training.
  • One to One live interaction with a trainer.
  • Demo project end to end explanation.
  • Interview guidence with resume preparation.
  • Support with the trainer through E-mail.

    Informatica has several products focused on data integration. However, Informatica PowerCenter is the flagship product in the portfolio. It has become so popular that Informatica PowerCenter has now become synonymous with Informatica. So whenever I use Informatica on the blog now, it essentially means Informatica PowerCenter. Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organizations including telecommunication, healthcare, financial and insurance services.

Live Traffic

Live Traffic Feed

Registration

Enquery

conveytechlabs