Rajnees

162 Hopkins Avenue, Jersey City, NJ

Mode:

Online Inclass

Claimed Profile

Get consultation

Name
Email
Phone number
Enter course
Enter course
Online Training Classroom Training

Contact Trainer

T & C apply

About Rajnees

Informatica

We offer a 6 Week intensive Informatica Training followed by

Interview guidance and technical support during the 1st project.
Instruction will be both in class and online. Students will be given 24/7
Access to Informatica Software (Power Center 8.6, Power Exchange 8.6).
LimitedAccommodation is available*

Eligibility: Preferably BS/MS in CS/ IS/ IT, IT Professionals. Candidates from Non-IT background are also welcome if they are willing to devote at least three (3) hours a day.

Module : ETL Developer Target Audience: IT aspirants and IT Professionals looking to switch fields Topics Data Warehousing Concepts, SQL, PL/SQL, Informatica 8.6, Live Project Total Hours 54 ( Approx 6 weekends)

Course Details

Week 1:

Data Warehousing

Introduction to Data warehousing: Types of Systems, OLTP, DSS, Maintenance of Data warehouse, Data warehousing Life Cycle, Datawarehousing Testing Life Cycle, Data warehousing Architecture,Source, Integration Layer, Staging Area, Targets, Analysis & Reporting, ODS.

Data Modeling

Introduction, Different phases of Modeling, Multi Dimensional Modeling , Dimensions, Facts, Multi Dimensional Model Hierarchies,OLAP, MOLAP, ROLAP, HOLAP, Cubes and their Functions, Star Schema, Fact Table, Dimensional Tables, Snow flake Schema, Factless Fact Table, Confirmed Dimensions

Week 2:

Day 1: SQL Basics	Day 2: Informatica	Day 3: SQL Continued
Introduction to Relational Database Systems: ORACLE, DB2, SQL Server Introduction to SQL:Basic SQL commands, the SELECT Statement,Ordering the output, Conditional retrieval of data , Working with variables Pseudo columns and functions, character functions, date functions , Using non-character function multiple tables, Different type of Joins, Writing Outer Joins ,Using the SET operators Aggregating data using group functions	Introduction to Informatica, Overview, Basic Definitions, Informatica Products, Informatica Architecture, Tools and their roles, Folders Sub Folders Power center, Differences between 7x and 8x	Creating Subqueries Enhancing groups function ,Transaction Control Language, Rollback, Commit, Processing hierarchies , Creating the Tree structure, Data Manipulation Language Data Definition Language, Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null

Week 3:

Day 1: Informatica Designer

Day 2, 3: Transformations

Introduction to designer, Designer interfaces, Designer tools, Defining Sources, Database as a source, Defining Targets, Importing from database, Creating a new target Creating target database objects Mapping Introduction, Ports, Mapping Table to Table, Mapping flat file to Table

Expression Transformation, Aggregator Transformation, Joiner Transformation, Homogeneous, Heterogeneous, Sequence Generator Transformation, Rank Transformation, Router Transformation,Union Transformation, Source Qualifier, Source Qualifier Transformation, SQL override in Source Qualifier Transformation,Mapping Source Qualifier as Filter Source Qualifier to join data, Flat Files sources & targets, Delimited Fixed width, Debugger

Week 4:

Day 1, 2:

Day 3:

Lookup: Static, Dynamic, Unconnected, Cached & Uncached,Customized Named Cache use technique from static & dynamic lookup Flat file lookup, Handling sub second precision for a Lookup transformation, Filtered lookup Mapping Wizards, Implementing of SCDs (Each types by at least by five Methods), Type-I, Type-II, Type-III

SQLT, Normalizer, Transaction Control, Stored Procedure Transformation, XML Transformation, Custom Transformation Informatica Workflow Manager Workflow Introduction, Tasks, Workflow Tools, Connections Defining Tasks, Command Task, Email Task, Session Task Link Conditions,Event Wait & Event Raise, Setting properties of Session Task ,Creating Workflow, Starting Workflow, Monitoring Workflow,Workflow Parameters

Week 5 (day 1,2):

Advanced Topics Incremental Aggregation, Mapping Analyst for Excel (MAE), Push-down Optimization Mapplet Implementation, Meta Data Backup & Restore,Copying Repository, Sending Notification Messages, Informatica Tuning,User Defined Function, Version Control, Copy folder and Deployment,Shortcut, pmcmd commands

Week 5 / 6:

PROJECT

The project will be conceived and developed by the group from scratch,right from gathering requirement to final mappings. Various persons will assume various roles and the roles will be interchanged as the project progresses. The project may be based on Insurance/ Financial/Pharmaceutical industry

Support during the 1st project

Technical Support will be provided to Individuals throughout the 1st project/1st Year
Certification Guidance
Individuals interested in Preparing for Certification in Informatica will be given the required material and guidance

Unix

Summary

We offer a 4 week intensive course in POSIX with a concentration on UNIX ( SOLARIS & HP ) and Enterprise Linux to train IT professionals and students followed by extensive interview preparation by industry experts to enable the students reach an industry-demanding expertise in System Admin and related work.

Course Detail

Week1 Day 1		Week 1 Day 2,3
UNIX Overview, UNIX File structure, Basic Commands		UNIX Shell, Editor, UNIX Man Pages, Basic UNIX commands
Week 2 Day 1		Week 2 Day 2,3,4
UNIX Shells and Shell Commands Bash and Korn Shell UNIX commands Vs Built-in Shell Commands		UNIX Editors VI, VIM, EMACS and Others UNIX Shell Scripting Regular Expressions ,AWK ,SED
Week 3 Day 1		Week 3 Day 2,3
The root and users File Permissions Creating /Removing Users Installing OS/Software Patches		Networking, Adding/Removing Hardware Backup Strategies and Tools Remote Administration Tools
Week 3 Day 3,4		Week 3 Day 5
Advanced Sheel Programming		UNIX Utilities
Week 4 Day 1,2	Week 4 Day 3,4,5
Installing the UNIX OS, File Partitioning, Project	Developing Applications in C/C++, Project

Business Object

Summary

Intensive Five weeks training (In-class and online) in Business Objects including Real-Time Project to help achieve expertise in the industry leading reporting tool followed by a full scale preparation for interview with mock interviews by our panel of experts.

Course Detail

Week: 1
Day 1:

Business Objects Overview
Business Objects Architecture
Tools and their roles
Business Intelligence/DWH concepts

Day 2:

Business Objects Introduction
Documents
Reports
Blocks
Universes, Classes and Objects
Data Providers

Day 3 :

User Interface:
Toolbars and Menus
Help
The Data/Properties Zone
The Status Bar

Week: 2
Day 4-6:

Reports and Analyzing Data
Editing Blocks to Manipulate Data
Adding Blocks to an Existing Report
Creating Sections in Reports
Adding New Reports to a Document
Using the Query Panel
Editing a Query, Building a Query
Running a Query
Simple Query Filters
User Defined Single Value Conditions
Pre-Defined Query Filters
Filtering, Sorting, Ranking Data
Using Alerts
Inserting Simple Calculations

Day 7

Report presentation styles
Tables, Crosstabs, Charts and Forms
Formatting Blocks
Formatting Pages
Formatting Breaks
Special Fields
Using Headers and Footers
Adding Logos and Pictures
Creating Templates

Week: 3
Day 8-9

Using Multiple Data Providers
Understanding the concept of a Data Provider
Multiple Queries (Data Providers) from a Single Universe
Naming Data Providers
Querying Multiple Universes in a Single Document
Using Personal Data Files (Eg. Microsoft Excel spreadsheets) as Data Sources
Synchronizing Data Providers by Linking

Day 10

Defining and Using Variables
Creating Variables
Resetting Calculations across Breaks
If..Then…Else Variables
The Group Function
Creating a Variable Using the Group Function
Understanding Calculation Contexts

Day 11

Using Slice and Dice
The Slice and Dice View
Converting Tables to Crosstabs
Converting Table Blocks to Charts
Adding Breaks, Totals, Filters and other Functions

Day 12

Drilling
Understanding Hierarchies
Setting the Scope of Analysis
Pre-Defined Hierarchies
Drilling on Single Hierarchies
Drilling on Multiple Hierarchies
Creating Custom Hierarchies
Drilling on Charts
Displaying the Drill Information
Saving Snapshots

Week: 4
Day 12

Semantic Layer (Universe) creation

Day 13-16

Real-Time Project

Week: 5
Day 17-20

Real-Time Project

TeraData

Summary

We offer a five weeks intensive training in Teradata covering from the very basics to advanced level to meet with the current and future industry demands of database management. training involves Real-time project, interview preparation and mock interviews by a team of subject experts.

Course Detail

Week: 1

Introduction to TERADATA

UInique Features of Teradata

Teradata System

Node component

SMP & MPP

BYNET Hardware &SoftWare

Communication between Nodes

Teradata Maximums

TERADATA Architecture

Architecture Flow

Shared Nothing Acrhitecture

PE with Explain

Visual Data Layout

Primary Index

Purpose of Primary Index

Non unique Primary Index

unique Primary Index

Secondary Index

Purpose of the Secondary Index

Unique Secondary Index

Non Unique Secondary Index

Week: 2

Teradata SQl

SQL Basics

Teradata Punctuation

HELP,show,Explain

Working With Nulls

And ,OR,Not, Between & like

Aggregation

Subqueries & Co-related Sub Queries

Aliasing,Title,cast &format

Interrrogating Data

Types of Tables

Set and Multiset Tables

Volatile Tables

Derived Tables

Global Tempory Tables

Teradata Spaces

Perm Space

Spool Space

Term Space

Performance Tunning with Space

Joins

Join Types

Join strategies

Join Index

Week: 3

Set Operators

Union/Union all

Intersect

Except or minus

Views

Purpose Of view

Create View Syntax

Usage

Macros

Purpose of Macros

Create Macro Syntax

Data and Times

Teradata Key words

Storage of dates on Disk

DateForm

ADD_Months Command

Extract Command

System Calender

System Calendar with Date Comparision

Intervel Processing with Date And Time

Rank Function and Qualify Usage

Rank Functions

Qualify Usage

Rank with OLAP functions

OLAP Function

CSUM

MSUM

MAVG

Week: 4

Teradata Utilites

MLOAD

FLOAD

FAST EXPORT

BTEQ

Locks

Exclusive

Write

Read

Access

Protection Features

Fallback

Raid

Clique

Stores Procedure

Performance Tuning

Project

Week: 5

Project

Rajnees Training Courses

View All Courses

-
DW BI

+
Linux Unix

Business highlights

IT Professionals as Trainers

Learning a technology with a professional who is well expertise in that solve 60% of your needs.
Hands-on Training

We support any training should be more practical apart from theoretical classes. So, we always give you hands-on training.
Affordable Fees

We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.
10000+ old students to believe

We satisfied 10000+ students from the day we started GangBoard
Counselling by Experts

We have every course material to understand which is prepared by our trainers and we will share with you after session completes.
Own Course Materials

We have every course material to understand which is prepared by our trainers and we will share with you after session completes.