Price: 1.00 ₹

Description

Best Informatica training in Chennai – Contact Dinesh @  9840496320 /  9940516384 / 044-43511623


Demo class Available on All days


 


My training tends towards real time requirement as well as interview / certification point of view.


 


About myself


I work as a Senior Data warehousing consultant for a Leading MNC in Chennai with 9+ years experience in both software development and training.


 


Qualification: B.E., MIS (USA), PMP


 


Informatica Professional Certification


Informatica Certified Administrator


Informatica Certified Designer


Informatica Certified Consultant


Data Integration, focused on PowerCenter product suite


Data Quality, focused on Data Quality product suite


MDM, focused on MDM Hub configuration


Velocity, focused on project implementation methodology


 


My training benefits


•My batch sizes are generally very small size 3-4 members OR 1 to 1 also, so students receive direct, hands-on training from us.



•100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.



•Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)



Please reach out to me for any further clarification.


Fast track available


 


Contact:  Dinesh Jaganathan


044-43511623 /  9840496320 /  9940516384


 


 


Informatica training in chennai |Informatica  course in chennai |Informatica  institute in chennai | Informatica training Institute in Chennai Adyar


 


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 (Practical not Included)


 

More Details

Total Views:7
Reference Id:#107152
Phone Number:9840496320
Website URL:Click To Visit
Current Rating: 5.0/5 2 Vote
Copyright © 2019 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com