Course Details

Informatica Overview

Informatica Training, Informatica is a tool, supporting all the steps of Load process, Extraction and Transformation. Nowadays Integration tool is also known as Informatica. The latest version trending now in the market is Informatica v10.

Informatics is a simple tool to use. It has got an easy observable interface like forms in visual basic. You must need to drop and drag different informatica transformations and load and layout process flow for Data extraction transformation. This progress flow layout familiar as mappings. Once a mapping is made, it can be demanding to run as and when deserved. The Informatica server fetches the data from source, load it to the target systems/databases and transforming it.

CourseInformatica Online Training
Mode of Training Instructor Led Live Informatica Online Training
Duration 30 hours
Timings Flexible (Our Rep will work with you on the timings that suits your needs)
Course Material Our Expert Trainer will share you all the necessary informatica study material, ppts, videos and pdfs
Examples Trainer will cover Real time scenarios during the training
Interview Questions Click here to see the Interview Questions
Certification Click here to know about the Informatica Certification
Salary Trends Check here to see the salary trends here.

  • Introduction of Informatica basics.
  • Learn about the data warehousing concepts
  • How the Dimension tables used and OLAP
  • Learn PowerCenter components
  • Informatica Architecture
  • Learn about source qualifiers
  • Look Caching and techniques
  • Worklets tasks
  • Advanced concepts on Informatica V10.

  • ETL & SQL Developers and Business Intelligence Professionals
  • Database & Mainframe Professionals, Project Managers

Tekslate Classes is the best Online Informatica Trainings classes through staff LED-Online preparing, classroom preparing and through Self-Paced Video learning. Our Informatica Tutorials authority staff will lead you till the finish of the Informatica courses and our pros will help the association and individual students to increase required and commonsense information of each module in Informatica Latest Version. Informatica training in Bangalore is set up according to the business measures and desires, everybody can get best profession open doors by taking our Informatica Trainings web based preparing. What’s more, we are likewise giving Informatica preparing.

Tekslate Classes give the finest Informatica tutorials videos recordings completely through our Informatica Self-Paced course. These Informatica Latest Version preparing recordings are sorted out by industry staff educators who have sound learning in the Informatica Latest Version. By taking Online Informatica Trainings self-guided preparing you can be prepared the aggregate course at your individual pace. Online Informatica video tutorials are incorporated with continuous situations by the skilled staff.

Classes are conducted by Certified Informatica Working Professionals with 100 % Quality Assurance. With an experienced Certified practitioner who will teach you the essentials you need to know to kick-start your career on Informatica. Our training make you more productive with your Informatica Training Online Videos. Our training style is entirely hands-on. We will provide access to our desktop screen and will be actively conducting hands-on labs with real-time projects.

  • Tekslate services are Student-centered learning.
  • Qualitative & cost effective learning at your pace.
  • Geographical access to learn from any part of the world.

Informatica Training Course Curriculum

Learning Objective : Introduction to data warehousing and the basic uses of it via overview. Different dimensions as SCD1, SCD2, SCD3 intro.

Topics Include : What/Why/How Data warehousing, USlowly Changing Dimensions (SCD1, SCD2, SCD3).

Practicals Covered : Hands on working with Informatica basics and data warehousing concepts and work on the different dimensions SCD1, SCD2, SCD3.

Learning Objective : Introduction into dimension tables types and table creations using Fact Tables, What is OLTP & OLAP and the basic difference between OLTP & OLAP and know about the advantages of Them.

Topics Include : Types Of Dim Tables, Fact Table, Types of Fact Tables, OLTP (OnLine Transaction Processing), OLAP (Online Analysis And Processing), OLTP Vs OLAP, Advantages of OLAP.

Practicals Covered : Know about the basic difference between between OLTP & OLAP. Create different tables including Fact Table. Create the tables and load the tables with sample data.

Learning Objective : Know about the powercenter components and user interface and its architecture & what are the clients tools. Learn how to use Designer. Know how to monitor and manage workflow.

Topics Include : Informatica PowerCenter Architecture, Informatica PowerCenter Client Tools, Start Using of the Designer, Workflow Manager and Workflow Monitor

Practicals Covered : Start with the designing in designer and overview of the powercenter architecture and work on the tools of powercenter client tools and work on the Workflow manager and monitor the workflow to know the process of flow.

Learning Objective : Know what is Source Qualifier, How to SQL override in source qualifier transformation, How to transform joints concept in Source qualifier, How to transform in Relational Databases for Source Qualifier, How to transform the File system in Source Qualifier, How to Use Filters in Source Qualifier, The basic difference between SQL Override, how to transform Performance Tunning source qualifier. know about pre and post SQL concepts used in Source Qualifier.

Topics Include : Source Qualifier Transformation, SQL override in source qualifier transformation, Source qualifier transformation joins concept, Source qualifier transformation on Relational Databases, Source qualifier transformation on File systems, Source qualifier transformation filter concepts, Difference Between SQL Override, Other Options, Source Qualifier Transformation Performance Tunning, Pre SQL and Post in Source Qualifier Transformation

Practicals Covered : Work on the Source Qualifier transformation by performing SQL override transformation. Work with SQL joints concepts, Relational Database concepts, File Systems, Filter concepts of Source Qualifier. Know the basic difference between SQL override and Perform Performance tuning  withe pre and post SQL commands on Source Qualifier.

Learning Objective : Know how to schedule job to scheduler and deep nalysis of the expression, filters and file lists and how to manage workflow scheduler and work on few sample work flow procedures. How to resolve real time issues.

Topics Include : Expression Editor, Filter Transformation, File Lists, Workflow Scheduler, Lab – Load the Customer Staging Table and Real time issues, Expression Normalizer Transformation in Informatica.

Practicals Covered : Work on the expression editor with files and apply filters to each of them and schedule a job to the scheduler  and load customer data into staging table and resolve real time issues by working on them.

Learning Objective : Know about the Joins and feature techniques like shortcuts and joiner transformations and load sale in the transaction tables and how to perform the known techniques on real time issues.

Topics Include : Joiner Transformation, Shortcuts, Lab A – Load Sales Transaction Staging Table, Lab B – Features and Techniques I and Real time issues

Practicals Covered : Perform 1.Lab A – Load Sales Transaction Staging Table with sample data, 2.Lab B – Features and Techniques I and Real time issues and hands on joins of SQL with the table data.

Learning Objective : How to view lookup and reusable informatica transformations and How to work on the employee staging table and load both date staging table  with real time issues.

Topics Include : Lookup Transformation in Informatica, Reusable Transformations, Lab A – Load Employee Staging Table, Lab B – Load Date Staging Table and Real time issues, Informatica Transformation with Examples, XML Transformation in Informatica, Normalizer Transformation in Informatica.

Practicals Covered : Work on the lookup transformations  and reuse them. Perform the action of employee staging table and load and with the staging and table and resolve the real time issues.

Learning Objective : Learn how to Debug Mappings by using the debugger for analysis.

Topics Include : Debugging Mappings, Lab – Using the Debugger

Practicals Covered : Work on Debugging Mappings with the use of debugging tools for complete analysis of the mappings.

Learning Objective : Learn about the sequence generation transform and work on the data with sample data by loading the date in Date Dimension Table and Know how to work on real-time issues.

Topics Include : Sequence Generator Transformation, Lab – Load Date Dimension Table and Real time issues

Practicals Covered : Generate sequence and perform informatica transformations. By performing sample analysis of date in dimension table and resolve real-time issues.

Learning Objective : Learn how to perform caching and load data promotions in dimension table  and include few techniques in loading the data and review the activities with real time work process issues.

Topics Include : Lookup Caching, Lab A – Load Promotions Dimension Table, Lab B – Features and Techniques II, Review and more Lab Activities and Real time issues

Practicals Covered : Hands on caching & Loading data with promotions into dimension table and include the latest techniques and perform the features included in it and monitor the work process by resolving real time issues.

Learning Objective : Learn how to transform the router, How to transform update strategy, How to express default values, How to override source qualifier,  and target override, How to override task mapping session, and follow all these with an example of employee dimension table and compare with real-time issues.

Topics Include : Router Transformation, Update Strategy Transformation, Expression Default Values, Source Qualifier Override, Target Override, Session Task Mapping Overrides, Lab – Load Employee Dimension Table and Real time issues

Practicals Covered : Perform the transformation on router, update strategy transformation and express the default values. Perform the source qualifier override and target it. Override the task mapping session and including all the above with an example of Employee dimension table comparing to real time scenario.

Learning Objective : How to create dynamic lookup, How to include error logging by performing with sample data or include customer dimension table.

Topics Include : Dynamic Lookup, Error Logging, Lab – Load Customer Dimension Table

Practicals Covered : Create the dynamic lookup and error logging for any sample data using or take a customer dimension table and analyse the following withe above.

Learning Objective : Learn how to include unconnected lookup, system variables, the mapping parameters and variable consideration of all the above including an table.

Topics Include : Unconnected Lookup Transformation, System Variables, Mapping Parameters and Variables, Lab – Load Sales Fact Table, Lookup in Informatica.

Practicals Covered : Create a Unconnected Lookup and transform the data using different system variables, mapping parameter varaibles and the following in a table of Sales Fact Table.

Learning Objective : Learn how to sort transformation and ways of transformations either active or passive. How to concatenate the data using self joins with a example by reloading the employee staging table  with real time issues resolving by working on SCD type1, SCD type2, SCD type3

Topics Include : Sorter Transformation in Informatica, Aggregator Transformation, Active and Passive Transformations, Data Concatenation, Self-Join, Lab – Reload the Employee Staging Table and Real time issues, SCD type1 – Hands-On LAB, SCD type2 – Hands-On LAB, SCD type3 – Hands-On LAB

Practicals Covered : Work on sorting transformation process in different ways of active or passive. Concatenate the data using self joins with a example by reloading the employee staging table  with real time issues resolving by working on SCD type1, SCD type2, SCD type3 ways of transformations.

Learning Objective : Learn about mapplets and load to calculate the daily aggregate of the table and related activities with real time performance.

Topics Include : Mapplets, Lab – Load Product Daily Aggregate Table, Review and more Lab Activities and Real time issues

Practicals Covered : By creating mapplets and working on the daily aggregate table of product and related lab activities like loading and performance analysis with the real-time examples.

Learning Objective : Learn how to perform tasks and workflow variables with link conditions, work flow variables, How to assign task, How to make decision in task, and email a taskwith product weekely aggregate table.

Topics Include : Link Conditions, Workflow Variables, Assignment Task, Decision Task, Email Task, Lab – Load Product Weekly Aggregate Table

Practicals Covered : Create link conditions and work flow variable with different work process and assign tasks with decision making tasks and email task for a product weekly aggregate table.

Learning Objective : Learn how to create event task for both Raise & Wait, How to Command table, Reuse a task & session and how to configure session reusable.

Topics Include : Event Raise Task, Event Wait Task, Command Task, Reusable Tasks, Reusable Session Task, Reusable Session Configuration

Practicals Covered : Create event task for both Raise & Wait and use Command table for assistance & Reuse a task & session for configuring session reusable.

Learning Objective : Learn about worklets and how to perform timer tasks  and how to control a task.

Topics Include : Worklet in Informatica, Timer Task, Control Task

Practicals Covered : Hands on different worklets using timer tasks and control the task using different procedures with an exact example for analysis.

Faq's

Tekslate basically offers the online instructor-led training. Apart from that we also provide corporate training for enterprises. Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Tekslate also verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from:

Popular cities of USA, like:

  • New York, Los Angeles, Chicago, Houston, Phoenix, Philadelphia, San Antonio, San Diego, Dallas, San Jose, Austin, Jacksonville, San Francisco, Columbus, Indianapolis, Fort Worth, Charlotte, Seattle, Denver, El Paso, Washington, Boston, Detroit, Nashville, Memphis, Portland, Oklahoma City, Las Vegas, Louisville, Baltimore, Milwaukee, Albuquerque, Tucson, Fresno, Sacramento, Mesa, Kansas City, Atlanta, Long Beach, Colorado Springs, Raleigh, Miami, Virginia Beach, Omaha, Oakland, Minneapolis, Tulsa, Arlington, New Orleans, Wichita, Cleveland, Tampa, Bakersfield, Aurora, Honolulu, Anaheim, Santa Ana, Corpus Christi, Riverside, Lexington, St. Louis, Stockton, Pittsburgh, Saint Paul, Cincinnati, Anchorage, Henderson, Greensboro, Plano, Newark, Lincoln, Toledo, Orlando, Chula Vista, Irvine, Fort Wayne, Jersey City, Durham, St. Petersburg, Laredo, Buffalo, Madison, Lubbock, Chandler, Scottsdale, Glendale, Reno, Norfolk, Winston–Salem, North Las Vegas, Irving, Chesapeake, Gilbert, Hialeah, Garland, Fremont, Baton Rouge, Richmond, Boise, San Bernardino.

Popular cities of Canada, like:

  • Toronto, Montreal, Vancouver, Edmonton, Hamilton, Ottawa, Calgary, Ontario, Qubec etc

Popular cities of India, like:

  •  Informatica Training in Hyderabad, Pune, Informatica Training in Bangalore, Informatica Training in Chennai, Delhi and Mumbai.

Along with it, we also prevail our valuable online training in the places of UK, Australia, India and other parts of the world

Certification

Informatica certification proves that you have good skills in data integration and data management projects. Informatica Certified Professional (ICP) program has various certifications like PowerCenter Developer Certification and PowerCenter Administrator Certification

  • Having an Informatica certification distinguishes you as an expert.
  • For Informatica certification, you need not go to a test center, as the exams are available online.
  • You need to register yourself at www.webassessor.com/ to give your Informatica certification exam.

Exam Details: Click Here…

Course Reviews

5

4500 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
        Profile photo of Suneel Kumar
        Chrissteve
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Profile photo of Suneel Kumar
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Profile photo of Suneel Kumar
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Profile photo of Suneel Kumar
        Alison Benhar

    Informatica Acquired Diaku and Introduces Data Governance Stand

    Date Published:22/2/2017

    Informatica, a leading company in providing data management software across the world has acquired Diaku, a UK-based data governance company. Axon is bellwether product of Diaku that governs the cluster of industries like Healthcare, Life Sciences, Financial services etc. It will be now recognized as Informatica Axon. Informatica will integrate Axon with data management, data quality and big data offerings…Read more

    Support


    Please leave a message and we'll get back to you soon.

    3 + 5