space
Search Courses  in 

Get CourseName COURSE FEES Instantly from BEST Training Institutes!

 

My City

I need details for

 

My Name

My Mobile Number

My Email ID

best infromatica training in chennai/adyar iskill

 

iSkill Tech
iSkill Tech

 

 

Information

Best Infromatica training in Chennai/Adyar iSkill Tech

Learn Informatica @ iSkill Tech

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 Infromatica training available
Real-time scenario project training
Flexible timing
Weekend batches available for working professionals.
Guidance to Informatica Cetification
100 % job assistance

Datawarehouse Concepts
1. Data Warehouse Introduction
2. Types of Datawarehouse
a. Enterprise Datawarehouse
b. Datamart
c. 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
e. Transformation Developer
f. Mapping Designer
g. Mapplet Designer
h. Task developer
i. Worklet Designer
j. 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
i. SCD Type1
ii. SCD Type2 -- Date, Flag and Version
iii. SCD Type3

8. Workflow Manger
a. Creating Reusable tasks
b. Workflows, Worklets & Sessions
c. Tasks
i. Session
ii. Assignment task
iii. Control Task
iv. Event raise task
v. Event wait task
vi. 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. Different kinds of Load
a. Initial Load
b. Incremental Load

 

Course Information

Informatica,
ETL, Fasttrack

 

Contact Information

Address: iSkill Tech,
New # 84 / Old #45-A, Venkatrathnam Nagar, Adyar, Chennai - 600020.
, Chennai , Adyar
PH: 9894994935 , 9894994935
Website: www.iskilltech.com
Email: iskilltech01@gmail.com
laureola solutions Chennai

 

Peridot Systems Chennai

 

Prolific Training India Plc Training

 

Talhunt TTA Training center insitute in Chennai

 

Core Mind Technologies Chennai Chennai

 

CADD School Vadapalani

 

Besant technologies chennaiThink up computer institute chennai

 

IICT Chrompet - SAP Training in ChennaiSatori Technologies Chennai

 

vgit kilpaukHB Services Adyar Training Institute

 

Credo Systemz VelacheryiSpark institute, Chennai

 

sap training institutes in chennaiITBMS chennai Best Training Institute

 

7 Eleven Arthashastra Chennai

 

IIHT Vadapalani Chennai

 

HITS computer Education chennai

 

HCL Learning Velachery Chennai

 

Training course fee & Discounts

 

 

 

 

   DMCA.com Protection Status