Price: 9500.00 ₹

No image available

Description

Best informatica training in chennai adyar - Chennai@iSkill Tech




Contact Prabhu +919894994935


Free Demo Class avaiable Daily!!


email: iskilltech@gmail.com


Branch:
New # 84 / Old #45-A, Venkatrathnam Nagar, Adyar, Chennai - 600020.
Besides Lawrence & Mayo
Opp to Hero Honda Showroom


Learn INFORMATICA @ iSkill Tech


• Informatica 8.6


Why iSkill Tech


Real time Experienced Faculty with more than 8 years of experience working in MNC's like Infosys,IBM,Wipro..
Limited Batch size
Online and corporate Informatica training available
Real-time scenario project training
Flexible timing
Weekend batches available for working professionals.
Guidance to Informatica Cetification
100 % job assistance






Course contents


Datawarehouse Concepts

1. Data Warehouse Introduction
2. Types of Datawarehouse
1)Enterprise Datawarehouse
2)Datamart
3)Operational Data Store
3. OLAP VS OLTP
4. Data Warehouse Architecture
5. Dimensional Modeling
6. Star Schema
7. Snowflake Schema
8. MultiStar Schema
9. Fact
10. Dimension
11. Slowly Changing Dimension
12. Confirmed Dimension
13. Junk Dimension
14. Change Data capture

E T L Informatica Power Center 8.6.x & 9.0.x


1. Power Center Components

a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor
e) PowerCenter Admin Console


2. Repository Administration


a) Creating Repository Users and Groups .
b) Connecting to the Repository.
c) Creating a Group
d) Assigning Privileges to a Group.
e) Creating a User
f) Creating a Folder
g) Folder Permissions
h) Creating Folders


3. Informatica Concepts and Overview


a) Informatica Architecture.
b) Informatica(Introduction)
c) Source Analyzer
d) Target Designer
d) Transformation Developer
e) Mapping Designer
f) Mapplet Designer
g) Task developer
h) Worklet Designer
i) Workflow Designer


4. Sources


a) Working with relational Sources
b) Working with Flat Files


5. Targets


a) Working with Relational Targets
b) Working with Flat file Targets

6. Transformations - Active and Passive Transformations


a) Expression
b) Lookup --Different types of lookup Caches
c) Sequence Generator
d) Filter
e) Joiner
f) Sorter
g) Rank
h) Router
i) Aggregator
j) Source Qualifer
k) Update Strategy
l) Normalizer
m) Union Transformation
n) SQL Transformation
o) Debugging Mappings


7. Mappings & Mapplets

a) Mapping Variables & Parameters
b) Creating Mapping,Mapplet and reusable transformation
c) Working with Mapping Wizards
d) Slowly Changing Dimension
1) SCD Type1
2) SCD Type2 -- Date,Flag and Version
3) SCD Type3


8. Workflow Manger


a) Creating Reusable tasks
b) Workflows, Worklets & Sessions
c) Tasks
1) Session
2) Assignment task
3) Control Task
4) Event raise task
5) Event wait task
6) Timer task
d) Monitoring workflows and debugging errors
e) Post session and Pre-session commands
f) Session recovery
g) Commit points



9. Performance Tuning


a) Informatica Tuning (Source, target, mapping & Session)
b) Informatica Pushdown optimization and pipeline partition
c) Incremental aggregation


10. Differnet Kinds of Load


a) Initial Load
b) Incremental Load


11. Unix Commands and Basics of Unix Shell scripting


12. Project - Case Study


13. Resume Preparation and Assignment






Job oriented training and Tips to empower professionalism and career.


List of the courses we offer:


§


Datastage


§


Informatica


§


Microstrategy


§


Ab initio


§


Cognos




§


Java j2ee


§




Dotnet




§


Oracle sql and plsql


§
Informatica


§


IBM MAINFRAMES


§


Embedded systems


§


Unix Shell Scripting


§


.NET


§


Cognos tm1


§


ITIL


§


Testing tools


§


Oracle 10g


§


Java/J2ee


§


business objects


§


Datastage
















best informatica training center in Chennai, best informatica training center in Chennai Adyar, best informatica


training center , best informatica training, best informatica, best Informatica ,Chennai,GOOD informatica TRAINING IN CHENNAI ADYAR JOB ORIENTED,informatica TRAINING IN CHENNAI ADYAR,informatica TRAINING IN CHENNAI,informatica TRAINING,informatica,Informatica , APPS ,informatica TRAINING IN CHENNAI,informatica TRAINING,CHENNAI,ADYAR,GOOD AND BEST informatica TRAINING IN CHENNAI ADYAR,VERY GOOD informatica TRAINING IN CHENNAI,VERY GOOD informatica TRAINING IN CHENNAI,GOOD AND BEST informatica TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST Informatica TRAINING INSTITUTE IN CHENNAI,informatica training in Chennai,informatica training center in Chennai,informatica training institute in Chennai,informatica,11i,10g Chennai,informatica training institute in Chennai,informatica institute in Chennai, best informatica 11i training center in Chennai, best informatica 11i training center in Chennai Adyar, best Informatica
training center , best informatica training, best informatica, best Informatica ,Chennai,GOOD informatica TRAINING IN CHENNAI ADYAR JOB ORIENTED,informatica TRAINING IN CHENNAI ADYAR,informatica TRAINING IN CHENNAI,informatica TRAINING,informatica,Informatica , APPS ,informatica TRAINING IN CHENNAI,informatica TRAINING,CHENNAI,ADYAR,GOOD AND BEST informatica TRAINING IN CHENNAI ADYAR,VERY GOOD informatica TRAINING IN CHENNAI,VERY GOOD informatica TRAINING IN CHENNAI,GOOD AND BEST informatica TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST Informatica TRAINING INSTITUTE IN CHENNAI,informatica training in Chennai,informatica training center in Chennai,informatica training institute in Chennai,informatica,11i,10g Chennai,informatica training institute in Chennai,informatica institute in chennai

More Details

Total Views:6
Reference Id:#68838
Phone Number:9894994935
Current Rating: /5 0 Vote
Copyright © 2019 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com