How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
+91 99001 13931
Outer Ring Road
Opposite Innovative Multiplex
3rd Floor
Above Unilet Showroom
Beside Nandas Hyderabadi Biryani
Marathahalli, Bangalore 37

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
Testing Tools
Selenium Testing
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
IBM MQ Admin
UI Development with AngularJS and Angular 2/4

Interview Questions Dot Net Video Tutorials
C# Programs
SQL Server
Trainer's Profile :
Data Warehousing and Informatica training is delivered by a real time working software professional having more than 10 Years of experience. The trainer has also been onsite in the United States and Canada for 3 years. 100% percent of the students got jobs on informatica. Attend the free classes and talk to the previous batch students to know about the quality of our training and placement assistance programs.
Training Approach :
  • The Trainer explains the concept from the basics.
  • After ensuring that every trainee has well understood the concept, the trainer will move on to explaining how to apply the same concept to a realtime project.
  • The trainer will then discuss all the possible interview questions related to the concept in general as well as relating to a real time project.
Data Warehousing Course Contents
Business Intelligence (BI) & Data Warehouse (DW):
  • Data Warehouse Architecture
  • DW Development Methodologies
  • DW Definition
  • What is BI?
  • Definitions of BI
  • Why BI?
  • Who needs BI?
  • DW Features
  • DW vs. OLTP DB
  • Data Mart, Staging DB, Operational Data Stores (ODS)
  • Top Down (Immon) Vs Bottom Up (Kimball)
Data Modeling (ER + Dimensional):
  • What is data Model?
  • E-R Modeling
  • Dimensional Modeling
  • Dimension table
  • Fact Table
  • Types Measures or Facts or Metrics
  • What is Schema and snowflake schema ?
  • Confirmed Dimension
  • Junk Dimension
  • Degenerated Dimension
  • Types of Fact Tables
ETL (Extract, Transform, Load) Process:
  • What is ETL process?
  • Functions of ETL process
  • Transformations Flow
  • Why Informatica for ETL process?
Informatica PowerCenter 9.5:
  • Introduction to Informatica PowerCenter
  • Informatica PowerCenter Architecture
  • Informatica PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
  • Informatica Server Administration Console
  • Creation of Informatica Integration Service, Informatica Repository Service, Folders, Groups, Users and Roles
Informatica PowerCenter Designer:
  • How to Create Straight Load mapping (One To One Mapping)
  • Concatenating FIRST_NAME and LAST_NAME using the Expression Transformation
  • How to filter the data from Flat File using Filter Transformation and Expression
    • Fixed width Flat Files
    • Delimited Flat Files
  • Different Row level Functions
  • How to Divide the data into multiple target tables using the Router Transformation
    • Filter Vs Router
  • How to write the data to Target file
  • Joiner, Sorter and Aggregation Transformation using Flat File and Relation tables
  • Heterogeneous Joins
  • Homogeneous Joins
  • Incremental Aggregation
  • Usage of Lookup Transformation
    • Different Types caches
    • Static Vs Dynamic Vs Persistent
    • Usage of Unconnected Lookup Transformation
    • Difference between Connected and Unconnected Lookup
  • Update Strategy Transformation
  • Insert, Update , Delete and Reject at mapping Level
  • Update Else Insert at Session Level
  • Finding TOP and BOTTOM ranked products by revenue using UNION and RANK Transformation
  • Reusable Transformations using Transformation Developer
  • Understanding Slowly Changing Dimensions
  • Implementing Slowly Changing Dimension Type 1
  • Implementing Slowly Changing Dimension Type 2
  • Implementing Slowly Changing Dimension Type 1 Using Dynamic Lookup Cache
  • Defining mapping Parameters
  • Different ways of Creating the Parameter File
  • Incremental load Using Mapping variables
  • Source and Target Based Commit Interval
  • User Defined Commit Interval
  • Invoking the Stored Procedure Transformation from Informatica PowerCenter
  • Connected Vs Unconnected Stored Procedure
  • Drop indexes using Stored Procedure
  • Create Indexes using Stored Procedure
Informatica PowerCenter Workflow Manager:
  • Sessions
  • Sequential/ Parallel Workflow
  • Email task
    • Session failure
    • Session Success
    • Workflow Failure
    • Workflow Success
    • Notifying support team with Success Rows, Rejected Rows, Failed Rows
  • Assignment task, Decision task, Control Task, Timer Task
  • Worklets
  • Command task
  • Scheduling Workflows
    • Informatica Scheduler
    • Third party Scheduling Tools
    • PMCMD
    • PMREP
Informatica PowerCenter Repository Manager:
  • Code Migration
  • Copying objects
  • Import/Export of objects
  • Deployment Groups
Performance Tuning:
  • Different methods used to find out the bottleneck
  • Session Partitioning
  • ROWID Partitioning
  • Commit intervals
  • Pushdown optimization
  • Various session level properties
Oracle SQL:
  • DDL and DML statements
  • Joins
  • Sub queries and Co-related sub queries
  • Indexes
  • Views
  • Set operators
Basic Linux/Unix commands and Shell scripting
Introduction to Informatica cloud and Practical sessions on Difference between on premise and Cloud Informatica
Disclaimer - Terms of use - Contact Us