• :+ 91-9908887609
  • : contact@maatrainings.com

Informatica Learning

  • Home
  • /
  • Informatica

Informatica Training Course Content :

About The Course

Maa Trainings is a One of the best quality training centre for Self-paced trainings. We are providing training throughout the world wide. Maa trainings self-paced programs are designed by keeping in mind about the people who are busy with their schedule. So it is prepared by Informatica expert who are real time working on Informatica. The course is developed by them in such a way that everyone will feel it easy to understand. You can go Through the free demo so that you will get clear idea about it. We provide have High Quality Video Recorded We provide related course material. You will get Lifetime access to the course you have selected. We have 24x7 technical support for your help.

  • Review:
  • Course Name

    Informatica
  • Course duration

    40-50 Hrs
  • Faculty

    Real time Expert
  • Category

    Selfpaced Learning
  • Support

    24/7 Technical Support

Who Can Learn

  • Professionals from Analysts background.
  • Software Developers
  • Web Developers
  • Fresher’s / Professionals from any field
  • Graduates looking for a career in Android..

With the growing era of technology and need to constantly update oneself to outstand in the competitive market, Maa Trainings has come to existence to provide people the knowledge about the latest trends in technology . We provide a team of trainers who will put across a thorough and detailed idea about the respective technical courses that you wish to explore . Our work doesnot end here. Maa Trainings gives an opportunity to work on real time projects which would be guided by our real time trainers. A technical back end team would always be available to answer your queries at any point of time and will also assist you to arrange your training sessions

Informatic Course Information

In MAA Trainings all trainers are well experts and providing training with practically..Here we are teaching from basic to advance. Our real time trainers fulfill your dreams and create professionally driven environment. In Tableau training we are providing sample live projects, materials, explaining real time scenarios, Interview skills…We are providing Best Informatic Training in Hyderabad,India

Course content

  • 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)/li>
  • Data Manipulation Language (DML)
  • Data Retrieval Language (DRL)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)

  • Conditional Selections and Operations
  • Where
  • Order by

  • Arithmetic operators
  • ARITHMETIC OPERATORS
  • +, -, *, /
  • Comparison operators
  • =, !=, >, <, >=, <=, <> • Between not between • in, not in • null, not null • like
  • Logical operators
  • And • Or • Not
  • USING ALIASES
  • FUNCTIONS
  • SINGLE ROW FUNCTIONS
  • Numeric functions
  • String functions
  • Date functions
  • Miscellaneous functions
  • Conversion functions
  • GROUP FUNCTIONS
  • Sum
  • Avg
  • Max
  • Min
  • Count
  • CONTROLS
  • Buttons
  • Text Fields
  • abels
  • Sliders
  • Progress
  • Switch
  • Web View
  • Image View
  • Segmented Control
  • Date picker
  • Picker
  • Alerts & Action Sheets
  • Page Controller
  • BASIC NS CLASSES
  • NSString, NSObject
  • NSArray, NSMutable Array
  • NSDictionary, NSMutable Dictionary
  • Other etc important classes
  • TABLES USING UITABLEVIEW AND UITABLEVIEWCONTROLLER
  • 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
  • Dimension and Fact

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

  • Additive
  • Semi-Additive
  • Non-Additive
  • Factless Fact Table
  • Granularity
  • Data cleansing
  • Surrogate key
  • Difference between a primary key and a surrogate key
  • Top Down approach
  • Bottom Top approach

  • 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

  • Difference between mapping level and session level variables
  • Session level variables Mapping level variables Sequence Generator Normalizer Transformation

  • Using parameter file
  • Using oracle Control tables
  • Transaction Control Transformation
  • Lookup
  • a. Connected
  • b. Unconnected

  • 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

  • SCD TYPE-III

  • 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.
  • Miscellaneous

  • 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
  • Third Party Tools

  • 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.

  • UNIT TESTING

  • Real time standard unit test cases will be explained.
  • Introduction about Deployment Deployment activities on different DB environments.

  • REALTIME DATABASE ENVIRONMENTS

  • TEST
  • DEV
  • QA
  • UAT
  • PROD

  • PROJECTS DEVELOPMENT

  • Migration Projects
  • New Development or Start up project
  • SUPPORT

  • Production Support /Enhancement Project
  • 24/ 7 Project
  • World class courses from our institute. Don’t hesitate to contact us for details