ETL and Informatica - Overview

This is a online course is to gain fundamental understanding of Informatica. The aim is to learn about Informatics and its features. The tutorials will help you learn about Key Features, Components and Concepts, Architecture and Components, Intergration Service, Informatica Designer and Workflow.

248

 2h 11m | 17 Videos | 89629 Views |   All Levels

Online Informatica Training

• An Informatica is a tool which supports all the steps of Extraction, Transformation and Load process. It is also being used as an Integration tool.
• Informatica tool is easy to use. It has got a simple visual interface as like forms in visual basic.
• You just need to drag and drop a different object which is known as transformation and design process flow for Data extraction transformation and load. These process flow diagrams are called as mappings.
• Informatica server takes care of fetching data from a source, transforming it and loading it to the target systems or databases.
  Informatica can communicate with all major data sources such as mainframe/ RDBMS/ Flat Files/ XML/ VSM/ SAP etc, can move or transform data between them.
• It can move large(huge) amount of volume of data in a very effective way.
• It can also do big updates in small chunks to avoid long locking and filling the transactional log.
• It can effectively join data from two different data sources even an XML file can be joined with a relational table.
• Informatica has got the ability to integrate heterogeneous data sources and converting raw data into useful information.
• Informatica enables organizations to gain a competitive benefit in today’s global information economy by empowering companies with relevant and trustworthy data for their top business imperatives.
• In short, Informatica is world’s leading ETL tools and its rapidly acquiring market as an Enterprise Integration Platform.
• Informatica Software Architecture:
  Informatica Software Architecture illustrated Informatica ETL product which is known as Informatica Power Center. It consists of 3 main components that are:

1. Informatica PowerCenter Client Tools:
Following are the development tools installed at developer end. These Informatica ETL tools enable a developer to
– Define transformation process which is known as mapping.
– Define run-time properties for a mapping which is known as sessions.
– Monitor execution of sessions
– Manage repository, useful for administrators
– Report Metadata

2. Informatica PowerCenter Repository:
– Repository is known as the heart of Informatica tool. It is a kind of data inventory where all the data related to mappings, sources, targets etc is kept.
– Repository is the place where all the metadata for an application is stored.
– Without repository, Informatica client and server is same as a PC without memory or hard disk, which has ability to process data but has no data to process. This is treated as backend of Informatica.

3. Informatica PowerCenter Server:
– Server is one of the places where all the executions take place.
– Server makes physical connections to targets, fetches data, applies the transformations and loads the data in the target system.

Why is Informatica Training required?

• Data is and has been from the beginning created, stored and retrieved by incompatible systems.
• Between 30% and 35% of all of the data in the industry is still on mainframes, in languages and data structures that are archaic and generally unavailable.
• The wave of specialty applications such as HR, sales, accounting, manufacturing has all contributed their share to the chaos.
• The latest development-growth in outsourcing, in all kinds including business processes, IT management and geographic will add even more complexity to the mix.
• So how do we integrate data from the disparate proprietary systems and applications, the billions of lines of code, combined with the additional complexity of outsourcing etc… So now for all these, an answer is Informatica.
• For all above reasons, knowledge of Informatics required.
• Informatica PowerCenter, an ETL tools of an Informatica works on basis of transformations which transform data in multiple ways.
• And also there is a reason for the necessity of an Informatica training.
• In a typical Data Warehousing environment, we use ETL tools like Informatica, SAS etc for extraction and cleansing and then using some Teradata utility.
• While the data load from ETL tools like Informatica, it is quite slow in execution as compared to Teradata utilities.
• The use of Informatica is just as we need to extract and cleanse data first before loading. So if we use Informatica tool for extraction and then use Teradata utilities for loading which may be the fastest solution.

Informatica Training Goal and Objective

• The primary goal of this course is to prepare students for a successful professional career in the Informatica.
• To get a good knowledge of Informatica tool.
• This course contains over 17 lectures and 2 hours of content.
• Learn the basic concepts, skills, and knowledge of Informatica
• Tremendous insight into the data integration platform
• Distributing the publication abroad on a contract of subscription and orders.
  students will be exposed to Informatica Velocity, troubleshooting techniques and the use of technical support options
• Who works in other technology but interested to learn Informatica tool, for them online learning platform is best because it saves time and other efforts.
• Developers who are new to Informatica require to implement data integration projects, exposing core features of PowerCenter, through lecture and hands-on exercises
• After completing the course, a participant can fluently work on Informatica tool.
• In simple words, the main objective is to make you awesome in Informatica technology.

Target Audience for Informatica Training

• Database developers who are interested to learn Informatica
• Administrators
• New developers who are interested to learn Informatica technology.
• Informatica or ETL tools beginners who want to learn more about the framework and best practices.
• All programmers or any IT Professionals
• Students who want to learn Informatica tool or technology from scratch
• All developers
• Computer Science Graduates
• Any experienced developer who has worked on Informatica technology.
• This online training course has been prepared for the beginners to help them to understand the basic to advanced concepts of Informatica tool.
• This online tutorial will bring you at an intermediate level of expertise from where you can catch yourself at a higher level of expertise.

Pre-requisites for Informatica Training

• Previous experience is not required
• Basic knowledge of Computers required
• Knowledge of a computer with internet
• Basic knowledge of databases
• Interest in to learn Informatica
• Such basic knowledge will help you to understand the Informatica concepts quickly and you can move fast on learning track.

Informatica Training Advantages

An Informatica is a data integration tool. Data integration tools vary from other software platforms and languages. They have no inbuilt element/feature to build a user interface. Some of the advantages are as follows:

• One of the major benefits of Informatica ETL tools is its capability of enabling Lean Integration, Lean manufacturing is a common concept.
• Informatica also leverage like integration model.
• Informatica ETL is moderate expensive tool whereas other tools are very expensive.
• Informatica comes with internal scheduler, unlike many other ETL tools where one needs to use the third-party scheduler.
• Informatica pursues mainstream marketing strategy where it leverages paperwork, press release, web forums and network community which provides it leading edge in ETL space. Another ETL player believes more on direct client marketing.
• Informatica sessions can be arranged logically into work lets and workflows in a folder.
• It leads to an ecosystem which is easier to maintain and quicker for architects.
• Easy to monitor jobs using Informatica Workflow Monitor. Also, have the ability to restart from failure step.
• Lots of connectors to various databases, including support for Teradata mad, trump, Fast Load and Parallel Transporter in addition to the regular ODBC drivers.
• Also, have the ability to publish processes as web services.

Back to top ^