INFORMATICA

Informatica is a Software development company.

INFORMATICA Online Training

Informatica is a data integration tool and as such provides native functionality for the export transform and loading of data. Teradata is a database, pure and simple. I wouldn't use a screwdiver to hammer a nail, I wouldn't use Teradata for ETL.

What you will learn

Technodips provides dedicated specialized Computer courses, which has spacious of opportunities in current software industry and supports the learners to develop their knowledge with up-to-date information. Technodips gives them quality guidelines to improve their knowledge. We provides the training to the learners in different concepts and modes to be the vital in the current Job market, having quality,skilled and current Industry expert faculty.

  • Introduction INFORMATICA

INFORMATICA Course Content

 

  • Data Ware Housing Concepts:
  • Introduction to Data Warehousing
  • Introduction to OLTP, ETL and OLAP Systems
  • Life Cycle
  • Data Modeling
  • Normalization Forms
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Types of Fact and Dimension Tables
  • Oracle Concepts:
  • Introduction to Oracle
  • Data Types
  • Constraints
  • SELECT statement usage
  • Joins
  • Sub Queries
  • Performance Tuning Tips & Tricks
  • Introduction to ETL
  • Enterprises of ETL Architecture
  • Introduction to Informatica
  • Installation & Configuration of Informatica
  • Repository Creation & Management

 

  • Designer
  • Source Analyzer
  • Warehouse Designer
  • Transformation Developer
  • Mapplet Designer
  • Mapping Designer
  • Different Kinds of Transformations
  • Simple Mapping
  • Mapping Involving Multiple Sources
  • Multiple Targets
  • Complex logic Mapping
  • Slowly Changing Dimension
  • Example of each Transformation available
  • Mapping Parameters & Variables
  • Performance Tuning Tips & Tricks
  • Debugging
  • Workflow Manager:
  • Task Developer
  • Worklet Designer
  • Workflow Designer
  • Different Kinds of Tasks and Usage
  • Control Tasks
  • Workflow Control and Monitoring
  • Performance Tuning
  • Session and Workflow Parameters
  • Project Related:
  • Real time Project Scenarios
  • Complete Real Time Project Exposure
  • Professional Resume Preparation
  • Mock Interviews
  • FAQ
  • Complete Job Assistance
Back to top