Trainings :        |    Certifications :    

Informatica

Duration: 3 Months


Join the course

itcerts.in is widely recognized for providing best Informatica Training in Noida that aims to teach the complete Data Warehousing Concepts in a simple manner. We are the best Informatica Training Institute in Noida in-terms of syllabus and professional teaching. We are covering almost all the transformations which are required for companies in Informatica, it makes our students best choice of companies.

Additionally, we have state-of-the-art infrastructure equipped with all latest tools and equipment, to provide our students a perfect learning environment. Our highly advanced and well-built infrastructure and best teaching techniques makes us candidates’ preferred Informatica Training Center in Noida, Delhi & NCR. Informatica is a data integration tool and efficiently provides native functionality for the export, transform and loading of data. It is a highly used ETL tool for extracting the source data and loading it into the target after applying the required transformation.

Being a well-known Informatica Coaching Institute, we nurture the students keeping the industry requirement in mind. Our expert trainers having great experience in their domain provide the training based on live projects to make the students expert to resolve any technical issue efficiently. During our Informatica Training in Noida, we conduct regular assessment to monitor the growth of learning of every student. Moreover, students need not to pay any high amount since we are offering this training at very reasonable fee structure.

Keeping pace with world of the rapidly changing technology, we have been capable to carve a supreme position as a foremost Informatica Training Center across the education industry. Further, we also provide the best assistance for the placement of our students, after the successful training completion. To place our students, we have association with various companies running across the world. Owing to our huge placement record, we have become the highly appreciated Informatica Coaching Institute. If you also want to become an expert in informatica, you can enroll yourself for informatica training provided by us at different batch timings.

Module 1
Data Warehousing Concepts

  • Introduction to Data Warehouse.
  • OLTP & OLAP Databases.
  • Stage EDW and Data Warehouse logic.
  • Difference between Data mart and Data warehouse.
  • Dimension Tables, Fact Tables and its Characteristics.
  • Concepts of Designing Star Schema, Snowflake Schema.
  • Primary Key and Surrogate Key, Foreign Key concepts.
  • Slowly Changing Dimensions and its different types.
  • Staging area and Repository Concepts for Data Warehouse.
  • Confirmed Dimension, Junk Dimension, Degenerate Dimension and Fact less fact table.

Module 2
Overview of Sql

  • DDL, DML, DCL, Data retrieval and Transaction control command.
  • Joins (Self Join, Equi Join, Non Equi Join, Full Outer Join, Left outer Join, Right outer Join).
  • Index Views Sequence Synonyms DB links.
  • Set operators.

 

Module 3
Introduction to ETL Process

  • Process of building data warehouse.
  • Introduction to Informatica.
  • Basic terms, concepts and definitions.
  • Components of Informatica.

Module 4
Informatica Repository Manager

  • Creating Users.
  • Granting Privileges.
  • Creating Repositories.
  • Creating folders.
  • Setting password and change password mechanism.
  • Introduction to Designer.
  • Understanding Designer Interfaces.
  • Designer Tools.
  • Informatica Design Process.
  • Introduction Methods of Source Analysis.
  • Defining Sources.
  • Creating Target Object Definitions.
  • Backup Export and Import of mapping.

 

Module 5
Mapping designer

  • Introduction to Mapping.
  • Working with Mappings.
  • Informatica Design Process.
  • Source Qualifier.
  • Ports.
  • Importing sources and Targets (RDBMS and Flat).
  • Mapping Designer.
  • Loading Plan.

Module 6
Transformations

  • Filter Transformation.
  • Expression Transformation.
  • Sequence Generator Transformation.
  • Rank Transformation.
  • Router Transformation.
  • Aggregator Transformation.
  • Joiner Transformation.
  • Update Strategy.
  • Lookup Transformation (connected and unconnected lookup).
  • Sorter Transformation.
  • Normalizer.
  • Union.
  • Stored procedure/Function transformation.
  • Query Overwrite.
  • Source File to target DB loading.
  • Source Database to Target file.
  • Implementation of SCD1, SCD2 and SCD3.
  • Surrogate keys.
  • Static and Dynamic lookup.
  • Push Down optimization.
  • Persistence cache.
  • Incremental aggregator.

 

Module 7
Informatica Workflow Manager

  • Creating Session and Command.
  • Connections Details.
  • Overwriting attributes like SQL query etc.
  • Setting and Connections at Client end in Informatica.
  • Creation of Workflow and execution of Workflow.

Module 8
Informatica Workflow monitor

  • Validating the source target statistics.
  • Checking the session logs and workflow logs.
  • Checking errors in the logs.

 

Module 9
Overview of UNIX

  • Standard 50 commands in UNIX.

 

Get In Touch


What People Said

Here in Feel IT Info tech, I was the student of INFORMATICA POWERCENTER ETL TOOL, well here i find the actual way of practical learning and direct work implementation with live examples as a company working nature in under professional working guidance

Roshan jha

My Salesforce Developer training experience has been great here. The trainer was well prepared and versed with both theoretical and practical aspects. He always encouraged the batch to raise the queries and resolved them successfully.
I would recommend this course to everyone

Abhishek Bhardwaj

According to my opinion it’s best training institute. We attended the course of Big data & Hadoop 3 months back & it was very practical and as per industry requirements & standards. A great opportunity to build your career.

Nitin Tomer

My experience of coming to itcerts.in was good as they connected me to the best trainer, I could get as per my requirement. Trainer did not just stuck to the syllabus and covered much more. He ensured I get everything that I desired from this training.
Thanks.

Neha sharma

I attended the course of Big Data , it helped me in building the concepts of Bigdata and Hadoop. It was complete hands on and practical oriented training.
One must attend for anyone who wants to learn things conceptually and want to excel in I.T.

Abhay goel

Customizing the training according to the client’s goals and participants’ profile is the remarkable quality of itcerts.in. Timely technological updation of the employees helps us in streamlining the job responsibilities

Mayank gupta

Our Courses Partners