Informatica Cloud Online Training

Informatica Cloud Online Training

Prerequisites to learn Informatica cloud Course

  • Basic knowledge of data warehouse
  • Knowledge of Oracle SQL.
  • Data Providing should be known and also informatica consultant for the Informatica Cloud Training.

Course Content:

Welcome to Informatica Cloud

  • About Informatica PowerCenter
  • Overview of Informatica Cloud
  • Informatica Cloud vs Informatica PowerCenter
  • Environment Configuration – Cloud Designer

SCD1 and SCD2 Implementing

  • Using Salesforce.com as Source and target
  • Using Flat File Source and Target
  • Run Mapping and Monitoring-Informatica Cloud

Task Flow Configuration

  • Task to run in Task Flow
  • Scheduling-cloud designer
  • Dependency Setup

Salesforce.com Error Handling

  • com Performance Tuning
  • com Real Time Integration (Outbound)
  • Cloud Administration – Cloud Designer
  • User and User Group

NVorkflow Tasks

  • Session
  • Assignment task
  • Link task-Informatica cloud
  • Event raise task
  • Event wait task

Transformation Creation

  • Creating Source Tables
  • Creating Target Definitions
  • Creating Target Tables
  • Creating a Pass-Through Mapping
  • Creating source definitions

Mapping

  • Connection (Source and Target)
  • Basic Mapping – Cloud Designer
  • Using different utilities in mapping

Configuration Task

  • Mapping Deployment
  • Data Sync Task
  • Replication Task- Cloud Designer

Advanced Options

  • Mapping Source Advance Options
  • Mapping Target Advance Options
  • MCT Advance Options
  • Deployment- Cloud Designer

Performance Tuning in ETL

  • Various Optimization Technique
  • Pushdown Optimization
  • Incremental aggregation
  • Error Handling
  • Performance Tuning
  • Log Handling