Informatica Learning

Informatica Training:

About The Course

Informatica is fundamentally known as tool for data integration and its entire module is based on a ETL architecture. Informatica is serving at present many industries which includes healthcare , finance , telecommunication , insurance services etc. Company benefits from this tool owing to its zero training costs as it is easy to learn and the company can add up plenty number of employees to this software. It is widely accepted most of the organizations and hence can definitely be a great career choice due to increase demand of Informatica specialists.

Course Name

Informatica

Course duration

40-50 Hrs

Faculty

Real time Expert

Category

Live Classes

Informatica Training Course:

  • SQL
  • PL /SQL Basics
  • Toad and SQL Developer Tools
  • Data Warehouse
  • Informatica Power Center 9.6
  • Unit Testing
  • Deployment activities
  • Unix Basics and Shell scripting
  • Real-time Projects

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Retrieval Language (DRL)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)

  • Where
  • Order by

  • Arithmetic operators
  • Comparison operators
  • Logical operators

  • +, -, *, /

  • =, !=, >, <, >=, <=, <>
  • Between not between
  • in, not in
  • null, not null
  • like

  • And
  • Or
  • Not

  • Numeric functions
  • String functions
  • Date functions
  • Miscellaneous functions
  • Conversion functions

  • Sum
  • Avg
  • Max
  • Min
  • Count

  • Buttons
  • Text Fields
  • abels
  • Sliders
  • Progress
  • Switch
  • Web View
  • Image View
  • Segmented Control
  • Date picker
  • Picker
  • Alerts & Action Sheets
  • Page Controller

  • NSString, NSObject
  • NSArray, NSMutable Array
  • NSDictionary, NSMutable Dictionary
  • Other etc important classes

  • UITableView
  • UITableViewDelegate and UITableViewDataSource
  • UITableViewDelegate
  • UITableViewDataSource
  • Adopting the UITableViewDelegate and
  • UITableViewDataSource
  • UITableViewController.

  • Variables
  • Constants
  • Records
  • Conditional Statements
  • Procedures
  • Functions
  • Parameters-Procedure, Function
  • Exception Handling

  • Business Intelligence
  • Data Warehouse
  • What is a DataMart
  • What is the difference between a data warehouse and a Data Mart
  • OLTP
  • ODS (Operational Data Sources)
  • What is Staging area and why we need it in DWH

  • Star schema
  • Snowflake schema

  • Slowly Changing Dimension( SCD)
  • SCD-Type1– Current Data
  • SCD-Type2 – Historical Data
  • SCD-Type3 – Partial History
  • Confirm Dimension
  • Junk Dimension
  • De Generated Dimension

  • Additive
  • Semi-Additive
  • Non-Additive
  • Factless Fact Table

  • Power Center
  • Power Mart
  • Designer
  • Workflow Manager
  • Repository Manager
  • Integration Services
  • Repository Services
  • Integration Service Process (ISP)
  • Data Transformation Manager (DTM) Process
  • Session
  • Workflow
  • Source Definition
  • Target Definition

  • Source Qualifier
  • Filter
  • Expression
  • Router
  • Session Level UPDATE else INSERT
  • Mapping Level UPDATE else INSERT
  • Update Strategy Transformation
  • Mapping level
  • Session level
  • Joiner Transformation

  • Session level variables
  • Mapping level variables
  • Sequence Generator
  • Normalizer Transformation

  • Transaction Control Transformation
  • Lookup

  • Persistent cache
  • Re-cache from lookup source
  • Static cache
  • Dynamic cache
  • Shared cache
  • Aggregator

  • First row Function
  • Last row Function
  • Flat Files
  • Delimiter
  • Fixed Width
  • List Files

  • Effective-Date Approach
  • Flag Approach
  • Version Approach

  • Constraint Base Load in Session Level
  • Parameter Files
  • Rank Transformation
  • Stored ProcedureTransformation
  • Sorter Transformation
  • Input Transformation
  • Output Transformation
  • Union Transformation
  • SQL Transformation
  • Java Transformation Overview
  • XML Generator
  • XML Parser
  • Mapplet Input Transformation
  • Mapplet output Transformation
  • Some other IMP transformations
  • Performance tuning in Infomatica
  • Infomatica Session Log shows busy percentage
  • Target Update Override
  • Overriding the WHERE Clause
  • Difference between 7.x and 8.x and 9.X
  • Power Center 9.X Architecture.

  • Shortcuts
  • Recovery
  • Session Log
  • Debugger
  • Worklets
  • Active & Passive
  • Standard & Reusable
  • Scheduling
  • Email Task
  • Decision Task
  • Concurrent Workflows
  • Complex Mapping
  • Error Handling
  • Mapplets
  • Code Pages
  • Meta Data
  • Versioning

  • Putty
  • Edit Plus
  • FTP (File Transfer Protocol) – File Zilla

  • What is UNIX?
  • Files and processes
  • The Directory Structure
  • Starting an UNIX terminal
  • Listing files and directories
  • Making Directories
  • Changing to a different Directory
  • Copying Files
  • Moving Files
  • Removing Files and directories
  • Displaying the contents of a file on the screen
  • Searching the contents of a file
  • Pipes
  • Other Useful UNIX commands

  • Shell script to upload files in Infomatica server
  • Shell script to transfer files from Infomatica server to remote server
  • Shell script to load Data
  • Shell script to create indicator file
  • Shell script to create indicator file
  • Some other useful scripts.

  • Real time standard unit test cases will be explained.

  • Introduction about Deployment
  • Deployment activities on different DB environments.

  • TEST
  • DEV
  • QA
  • UAT
  • PROD

  • Migration Projects
  • New Development or Start up project

  • Production Support /Enhancement Project
  • 24/ 7 Project

FAQ’s:

Future for Informatica wannabees is definitely shining bright. There are plenty of job opening for Informatica specialists .

The pre-skills required before opting Informatica is coding , proficiency on programming with a wide understanding of when and how the database system works.

The answer to this is definitely YES. We chose trainers based on their corporate working experience in the respective domain and only those who are highly specialized in the IT domain. We focus on Quality rather than Quantity.

Our highly skilled staff at IT Tuition assists you for the placements and resume build up. They train you and help you gain confidence to face the interviews as well.

Here we are providing “Java Full Stack online training in Hyderabad”,Java Full Stack class room training in Hyderabad, “Java Full Stack corporate training in India”, Java Full Stack Class Room Training in Madhapur, Java Full Stack Online Training in Madhapur,In India Online services providing in top cities like Banglore,Chennai,Pune, Mumbai , Delhi, Etc,

Related Courses
Special Features

Popular Tags

Informatica training in hyderabad Informatica training in bangalorer Informatica training online in India Informatica training online in USA Informatica training in UK Informatica training in Singapore