26/06/2012 Professional & Short Term Course
Shinelogics is a Chennai based Software Firm. Our main focus areas are Software Training and Software Development. Shinelogics 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 Shinelogics
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
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
Caching concepts in Informatica.
Importance of Source Qualifier.
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
Monitoring Work flows
Using Multiple Servers
Row Error Logging
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.
Using Multiple Servers, Log files, Error, Row logging
Configuring Session caches lookup, Aggregate, Sort, Joiner caches.
Restart able Tables.
Reject Capture and Reprocessing.
Handling Soft\Hard Rejects.
Duration : 45 Working hours (Practical not Included)
BEST INFORMATICA TRAINING INSTITUTE IN CHENNAI, ADYAR, 9790855020 Get trained by well experienced professionals having 15 years industrial experience ...
Best INFORMATICA Training Institute in Chennai with placement...8056102481 No 1 Software Training Institute in Chennai with Placement Peridot is proud...
Best INFORMATICA Training Institute in Chennai placements.. No 1 Software Training Institute in Chennai with Placement Peridot is ...
Best Informatica Training Institute in Chennai | Informatica Training Institute – Besant Technologies, Chennai Best Informatica Training Institute Bes...