Informatica - An ETL Tool

  • (5.0)

The overview of Informatica is explained in the previous article Informatica PowerCenter.

Informatica relies on a ETL concept which is abbreviated as Extract- Transform- Load.

What is ETL?

It is a data warehousing concept of data extraction where the data is extracted from numerous different databases.

To get proficiency in Informatica. Join Online Informatica Training at Mindmajix. Enroll For Free Demo!

Who Invented ETL?

Ab Intio- a multinational software company based out of Lexington, Massachusetts, United States framed a GUI Based parallel processing software called as ETL.  The other historic transformations relating to ETL journey are briefed here.

Where do Informatica-ETL concepts apply in Real-Time Business?

Informatica is a company that offers data integration products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc. Informatica ETL is most commonly used Data integration tool used for connecting & fetching data from different data source. 

Some of the typical use cases for approaching this software are:

1. An organization migrating from existing software system to a new database system. 
2. To set up a Data Warehouse in an organization where the data is moved from the Production/ data gathering system to Warehouse.
3. It serves as a data cleansing tool where data is detected, corrected or removed corrupt or inaccurate records from a database.

How do Informatica - ETL tool is implemented?

1. Extract: 

The data is extracted from different sources of data. Common data-source formats include relational databases, XML and flat files, Information Management System (IMS) or other data structures. An instant data validation is performed to  confirm whether the data pulled from the sources has the correct values in a given domain. 

2. Transform:

A set of rules or logical functions like cleaning of data are applied on the extracted data in order to prepare it for loading into a target datasource. Cleaning of data implies passing only  the "proper" data into the target source. There are many transformation types that can be applied on data as per the business need. Some of them can be column or row based, coded and calculated values, key based, joining different data sources etc. 

3. Load: 

The data is simply loaded into  the target data source. 

All the three phases are executed parallelly without being waiting for other to complete or begin. 

What are other features of ETL Tool?

Parallel Processing:
ETL is implemented using a concept called Parallel Processing. Parallel Processing is a computation executed on multiple processes executing simultaneously. ETL can work 3 types of parallelism - 

1. Data by splitting a single file into smaller data files.
2. Pipeline allows several component to run simultaneously on the same data.
3. Component are the executables. Processes involved for running simultaneously on different data to do the same job.

Data Reuse, Data Re-Run and Data Recovery:
Each datarow is provided with a row_id and each piece of process is provided with a run_id so that one can track the data by these ids.  There are checkpoints created to state the certain phases of the process as completed. These checkpoint state us the need for us to re-run the query for completion of the task.

Frequently Asked Informatica Interview Questions

Visual ETL: 
The advanced ETL tools like PowerCenter and Metadata Messenger etc.,  that helps you to make faster, automated and highly impactful structured data as per your business needs.

You can ready-made database and metadata modules with  drag and drop mechanism on a solution which automatically configure, connect , extracts , transfers and loads on your target system. 

What are the characteristics of a Good ETL Tool?

1. It should increase data connectivity and scalability.
2. It should be capable of connective multiple relational database. 
3. It should support even csv-datafiles so that end users can import these files with less code or no code.
4. It should have a user-friendly GUI that makes end users to easily integrate the data with visual mapper.
5. It should allow end user to customize the data modules as per their business needs.

What is the Future of ETL?

Informatica -ETL products and services are provided to improve business operations, reduce big data management, provide high security to data, data recovery under unforeseen conditions and automate the process of develop and artistically design visual data. They are broadly divided into-

1. ETL with Big Data
2. ETL with Cloud
3. ETL with SAS
4. ETL with HADOOP
5. ETL with Meta data etc. 
6. ETL as Self service Access
7. Mobile optimized solution etc., there are many more.

ETL is expanding its wings widely across the newer technology as per the present enterprise Faster world  to value,  staff, integrate,  trust,  innovate and to deploy. 

Why is Informatica ETL is in boom?

1. Accurate and automate deployments
2. Minimizing the risks involved in adopting new technologies
3. Highly secured and trackable data
4. Self- Owned and customizable access to permission
5. Exclusive data disaster recovery,  data monitoring and data maintenance.
6. Attractive and artistic visual data delivery.
7.Centralized and cloud based server. 
8. Concrete firmware protection to data and organisation network protocols.

What are the side effects of Informatica ETL kind of automated data integration systems?

Anything in limit is good. But something like Data integration tool makes the organization to depend on it continuously. As it is a machine, it will work only when programed input is given. There is equal risk of complete crashing of the systems- how good the data recovery systems are build. Small whole is enough for the rat to build its cage in our house. Similarly, any sort of misuse of simple data leads to huge loss to the organisation. Negligence and carelessness are enemies to these kind of systems.

Explore Informatica Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!


List of Informatica Courses:

Mindmajix offers training for many of other informatica courses depends on your requirement:

 Informatica Analyst  Informatica PIM
 Informatica SRM  Informatica MDM
 Informatica Data Quality  Informatica ILM
 Informatica Big Data Edition  Informatica Multi Domain MDM


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules