23/06/2012 Computer - Multimedia Classes
Best informatica training institute in chennai/adyar
àDINESH B.E.MIS(USA),OCMà9940516384
àPARTHIBAN M.C.Aà9840496320
About Greens Technologys
Greens Technologys is a Chennai based Software Firm. Our main focus areas are Software Training and Software Development. Greens Technologys started with the ambitious aim of providing QUALITY training to Students and Corporate. We are integrated as an organization of talented trainers having extensive expertise in all facts of providing quality training. 5000 IT Professionals got trained and placed in various MNCs.
How we are no1 in Training & Placements
Who can join Greens Technology’s
About Informatica Training
Introduction to Data warehousing
Overview of a OLTP/Transactional system
Forms of Normalization
Pros/Cons of having an OLTP system in real time reporting.
Need of a data warehouse.
Data warehouse layer architecture.
Designing a warehouse using Star/Snowflake schemas.
Logical/Physical Models in Erwin
Introduction to Informatica/ETL tools
The role of ETL tools in data warehousing.
An introduction to Informatica
Informatica Architecture
Components/Process flow
Informatica Designer
Basic Concepts
Using the designer.
Working with the Sources-Source Analyzer
Working with Relational/Flat file targets- Warehouse Designer.
Defining Keys in Informatica.
Working with Transformations –Transformation Developer
Working with Mapplets- Mapplet designer.
Creating mappings –Mapping Designer.
Understanding Pipelines in mappings.
Setting Target Load order.
Configuring Constraint Based loading.
Introduction to Mapping Parameters/Variables.
Implementing Type1, Type2, and Type3 Mappings.
Loading Fact tables.
Working with Transformations
Active/Passive Transformations
Caching concepts in Informatica.
Connected/Unconnected Transformation
Importance of Source Qualifier.
Filter, Router
Expression
Sorter, Aggregator
Rank
Joiner
Lookup
Stored Procedure
Sequence generator
Union
Transaction Control
Update Strategy
Xml transformation
Normalizer
Creating Workflows
Understanding the server Architecture
Working with Workflows
Working with Tasks Assignment,Command,Decision,Control,Event raise,
Event Wait,Timer,Email,Session Task
Working with Work lets
Working with Sessions
Understanding Commit Points
Recovering Data
Monitoring Work flows
Using Multiple Servers
Log files
Row Error Logging
Session parameters
Parameter files
Using Incremental Aggregation
Real-Time Implementation with Informatica
Performance Tuning(With Real time Examples).
Using Incremental Aggregation
Extraction modes(Pull, Push).
Change Data capture concepts.
Incremental Extraction using control tables..
Session parameters and variables.
Session and Workflow properties Reference.
Pipeline partitioning.
Using Multiple Servers, Log files, Error, Row logging
Session Recovery.
Configuring Session caches lookup, Aggregate, Sort, Joiner caches.
Restart able Tables.
Reject Capture and Reprocessing.
Handling SoftHard Rejects.
Duration : 45 Working hours
Thanks
Greens Technologys,
No.15 First Street,Padmanabha nagar,
Adyar,
Chennai-20.
Best Regard’s
N.PARTHIBAN
Phone(M): +91 98404 96320
Phone(L): 044 43511623
eMail: greens.adyar@yahoo.com
www.greenstechnologys.com
Best selenium training in Chennai|Best selenium training & placement institute in Chennai *********************(GREENS TECHNOLOGY)****************...
best java training come placement center in Chennai | best java training institute in Chennai Adyar =======contact == Anbu====9840496320/9940516384===...
Best Corporate Training Institute in Chennai DINESH B.E.MIS(USA),OCM->9940516384àPARTHIBAN M.C.A-->9840496320 Well experienced corporate Trainer...
Best Oracle training come placement center in chennai ********Contact:- Anbu(9940516384/9840496320)******* Gree...
More Details