Real Time Informatica Training From Data Warehouse Experts

[intuites]

 

INFORMATICA

 

• Introduction to DWH Concepts:   What is a Data warehouse? Characteristics of DWH,  OLTP vs OLAP, Dimensional Model (Star & Snow flake schema), Types of Facts, Types of Dimensions, SCD's (type 1,2,3) , Surrogate key vs Business key. OLTP System, Data warehouse, Different Definitions of data warehouse, Difference between OPERATIONAL DS AND DWH, Types of ETL, Data Extraction, Data Transformation, Data Merging, Data Loading, Types of Data loading, Data Aggregation, Data warehouse Approaches, Top down approach and Bottom up approach ,DW Life cycle, DW-database design, Star schema and Snow flake schema, Dimensional modeling, Facts and dimensions,  Granularity, Types of Dimensions, Types of fact table, Types of Olap
• Informatica Administrator:
• Repository & Integration Service: Creating Repository Users and Groups , Connecting to the Repository, Creating a Group, Assigning Privileges to a Group,  Creating a User, Creating a Folder, Folder Permissions, Creating Folders.
• Introduction to Powercenter client: Informatica Power center architecture, Power center components, ETL Plan, Power center Clients, Designer, Workflow manager, Work Flow monitor, Workflow manager, Repository manager,  Power center repository, Administrative tool, Repository services, Integration services, Power center domain, Application services, Concept of nodes and grid, Service manager, Power center administration console.
• Concept of CSV (flat ) files:
• Concept of Version:
• Transformations:     Source , Target , Source qualifier, Expression, Filter , Router, Joiner , Update strategy, Sequence generator, Rank, Union, Lookup, Aggregator, Sorter, Normalizer, Transaction control, Mapplet, Transformations in Designer, Parameters & Variables, ,UDF.
• Workflow  Tasks:  Session, Assignment task, Link task, Event raise task, Event wait task, Timer task, ,Post session and Pre-session commands, Session recovery, Commit points, Creation of Parameter file, Mapping and session parameter
• Scenarios based on individual transformations & using multiple transformations
• Scheduling mechanism
• Performance tuning in Informatica & Database: Various optimization technique, Pushdown optimization, Incremental aggregation.

 

ORACLE SQL

• INTRODUCTION:  What is SQL?  , DDL Commands, Create, Alter, Drop, Truncate, Rename, DML Command – Insert, Update, Delete.
• SQL SELECT statements:  Order by Clause, Distinct Clause, Where Clause, Operators, Comparison Conditions.
• Constraints:  Primary Key Constraint, Unique Constraint, Not Null Constraint, Foreign Key Constraint, Check Constraint, Cascade Constraints.
• Joins:  What is a Join?, Cartesian Join, Equijoin, Non – Equijoin, Self Join, Outer Join, Left Outer Join,. Right Outer Join, Full Outer Join, Pseudo Columns.
• Functions:  Numeric Functions, Character Functions,. Date Functions, Conversion Functions, General Functions, Aggregating, Data Using Group Functions.
• Sub Queries:  Simple Sub Queries, Multiple Row Sub Queries.
• Update  :  Data Updating, Updating data using Sub Queries.
• Delete:  Deleting Data, Deleting data using Sub Queries, Deleting data using join.
• Transaction Control Language (TCL):  Commit, Roll back, Savepoint.
• Database Objects:  View, Synonym, Sequence, Index, Privileges.
• View: Simple View, Complex View, In Line View.
• Synonym: Private Synonym, Public Synonym.
• Privileges :  Grant, Revoke.

 

 UNIX-SHELL SCRIPTING

 

• Unix –Shell Scripting : History of UNIX, Features of UNIX, Flavors of UNIX, Comparison of UNIX with Windows, Architecture of UNIX.
• Different types of Files: Regular Files, Directory Files, Device Files.
• Basic Commands: pwd, logname, who, finger, Exit, date, cal.
• Creating Users & Groups: groupadd, groupdel, useradd, userdel.
• Working with files: cat, touch, rm, cp, mv.
• Working with Directories: mkdir, cd, rmdir, rm –r.
• Standard Input & Output: Redirecting output, Redirecting Input.
• Comparing Files: cmp, diff, comm
• Searching files: find, locate, which
• Zip files: gzip, gunzip
• Displaying files :  ls, ls options
• Viewing long files: pg, more, head, tail
• File Permissions: chmod, chown, chgrp, umask
• Regular Expressions & Patterns: What is pattern, Usage of regular expression, Different types of pattern, Character pattern, Word pattern, Line pattern.
• Tools for Filters: grep, grep with options, Flat files, What are delimiters and its types?,Reading and Writing to files.
• Tools for column data :cut, paste.
•  Piping: usage of piping, piping with filters, tee command.
• Job control: Foreground jobs, background jobs, Killing jobs, nohup.
• Process status: ps , ps with options.
• Editor Vi: 3  modes, Command mode, Insert mode, Ex command mode
• Shell-Scripting: What is Shell Scripting, Importance of shell scripting,  Different types of shells, Creating Shell Script, Making Shell Scripting executable, Shell input & output, echo, print, read.
• Operators: Arithmetic variables, Relational numeric operators, Logical operators, Assignment operators.
• File test commands, String test commands, Exit & Sleep commands
• Job scheduling: cron, at, batch.

 

Highlights of the Training :

 

1. The instructor is a Informatica Expert with 8+ years of Experience.
2. The training is 80% practical and 20% theoretical
3. Training with Realtime examples
4. Assignments for every 2 classes
5. Classes on all weekdays except occasionally on weekends.
6. Online training using Webex : Easy to install and record your own sessions
7. Trainer Certified by Intuites
8. Batches starting every 2 weeks.
9. Duration of the Training :   1 Month

 

       If Interested in Placement after training, we provide the following   :  

 

• Complete Mockup Sessions  for Vendor and Client  Interviews
• Resume Review and Preparation by Informatica Expert
• Dedicated recruiters to place you and excellent people to help with interviews.
• Strong relationships with many Prime Vendors and our direct clients for placements.
• Competitive Pay as per market, on-time payment with our transparent payment system.
• Our E-Verification may help you to get the extra 17 months extension on OPT
• Assurance of timely visa status upgrades from OPT/CPT/L1 to H1B and then Green card  with one of the nation’s best ranked immigration attorney

 

      For further details, please contact Pavan at (234)-542-3945 or by email at [email protected].

      If we missed your call, please leave us a message or send us an email.

 

 To know more about Intuites, please visit our website : www.intuites.com

 

 To hear more about Intuites in employees' words, please check out our reviews at   

www.facebook.com/intuites