Informatica Online Training

Informatica PowerCenter Training Course

Start learning informatica certification course & be a skilled professional in informatica powercenter, usaonlinetraining.com offers informatica online training in usa, canada, uk, australia, singapore, new zealand, mexico, uae, spain and brazil with experienced informatica trainers.

Complete Job Oriented Hands-on Training

Introduction to Oracle

Purpose

What is Oracle?

How to create Schema/User?

SQL Classification

  • Create (DDL)
  • Insert (DML)
  • Commit (TCL)
  • Select (DRL)
  • Update(DML)
  • Delete (DML)
  • Truncate(DDL)
  • Using DDL
  • Using TCL
  • Using DCL

Synonym

Conditional Selection Operators

  • WhereClause
  • OrderBy

Toad

Aliases

Functions

  • Row–Level Functions
  • GroupBy and Having Clause
  • Analytical Functions

Set Operators

Constraints

Joins

Case OR Decode()

Merge Statement

Sub–Queries

Correlated Sub– Queries

Views

Materialized View

Normalization

Indexes

Partitions

Query Tuning Approach

Difference between DELETE,TRUNCATE and DROP

Difference between ROWID and ROWNUM

Difference between WHERE and HAVING

PL/SQL Basics

  • Stored Procedure
  • Packages
  • Triggers

Important Queries

Index for DWH Concepts

DWH Concepts

What is BI?

OLTP

Data Warehousing

Data mart

What is Schema?

  • Star Schema
  • Snow –Flake Schema
  • Galaxy Schema

Fact Table

Granularity

Dimension Table

Data Modeling

SCD Type

Staging Area

Surrogate Key

Informatica Index

ETL

ETL Tools

Informatica

  • PowerCenter
  • PowerMart

Repository

Mapping

Structure of Designer

Session

Workflow Manager

Workflow Monitor

 Informatica Scenarios

  • One–to –One Mapping
  • Customizing the Source Qualifier
  • Concatenating First_Name, Last_Name and other Row Level Functions
  • Implementing if–else statement using Expression Transformation
  • How to filter the data using Filter Transformation
  • Multiple Filter Conditions using Filter Transformation
  • Need of Router of Transformation
  • Joiner Transformation
  • Transposing Columns into Rows using Normalizer Transformation
  • Transposing rows into columns using variable port and aggregator transformation
  • Combining Multiple Pipelines–using Union Transformation
  • Usage of Lookup Transformation
  • Unconnected Lookup
  • Update Else Insert at Session Level
  • Department wise Max Salary –using Aggregator Transformation
  • Update Strategy Transformation
  • Update Else Insert at Mapping level SCD Type
  • Sorter Transformation
  • Fixed Width and Delimiter Flat File
  • Populating Surrogate Key –using Sequence Generator
  • Source First Record into First Target and Second Record into Second Target
  • Multiple Flat Files into the target –Indirect File Type
  • Populating Source Flat File Name in the target table
  • Effective Date–SCD–Type
  • Preventing source duplicate records using Lookup Transformation
  • Cumulative Salary
  • Variables– Increment al Logic(CDC)
  • Control Table Logic
  • Committing at Mapping Level
  • Dynamic File Generation
  • Generating sequence numbers without using Sequence Generator Transformation
  • Assignment Task
  • Event Wait –File Watch Mechanism
  • Worklet
  • Command Task
  • Email Task
  • Stored Procedure
  • Differences between Informatica and versions
  • Incremental Logic Using Parameter File
  • Complex Mapping
  • Assigning a value to workflow level variable–using Assignment task
  • Handling Error Data
  • Loading Unique Records into one table and duplicate records into another
  • How to eliminate or avoid duplicate record from flat file to relational table
  • Generating multiple records in target based on source column
  • updating the target table, if target doesn’t have Primarykey
  • Performance tuning in Informatica
  • How to Load half records into one Target another half records into one target
  • Ways of creating Parameter file(Types of parameter files)
  • Development Code Standards
  • How to skip header and footer records while processing Source Files
  • Handling SurrogateKey, if same target table populated by two mappings and corresponding sessions execute parallelly
  • Unit Test Plan
  • Difference between Source Qualifier, Joiner and Lookup transformation
  • Difference between Dynamic Lookup Cache and Static Lookup Cache
  • Difference between Connected Lookup and Unconnected Lookup
  • Functioning the loops in Informatica while processing from source to target
  • Skipping or processing last nth records from Source Flat File
  • Development Lifecycle
  • Differences between Waterfall and Agile Methodology

Important Unix Commands