Best Informatica Training Institute in Chennai/velacherry

26/06/2012 Professional & Short Term Course

Price: 20000.00 ₹

Description

About Shinelogics


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


  • Real time Project Specific  training is the Key Success of Shinelogics and their Students.

  • Trainer with certified technical skill set.

  • Trainee Will be get Trained by Actual real world system.

  • Trainee Will be the certified Professional end of the every training program.

  • No hidden and commerical Training Cost.

  • No marketing Strategy to converting Students , Such no false commitments like 100% Placement and Assurance.

  • Trainee can closely with trainer until get complete their assignments or find better placements.

  • Never charged for Resume preparation and Placement Trail software install on your laptop.

  • Trainee can do lab assignment from home connecting to use our Advanced technologies such as cloud computing

  • Students can attend multiple session with one time pay.

  • Students never failed to get job in our past history.

Who can join Shinelogics


  • Fresh Engineers who can challenge their IT career.

  • Who worked in IT Industry and looking for their skills upgrade and certifications.

  • Who really need a break through and their career change.

  • People not worked in IT but can be a domain knowledge.

  • Who interested to work in abroad.

 


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 Soft\Hard Rejects.


 


Duration : 45 Working hours (Practical not Included) 

More Details

Total Views:5
Reference Id:#77798
Phone Number:9884837221/8754533233
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com