#informatica interview questionsinformatica interview questions and answers informatica interview questions and answers for experienced

[amarmytectra-blog]

Informatica Interview Questions and Answers

Q1).What Is Informtica?

Ans: Informatica is a Software development company, which offers data integration products. If offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc.

Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.

For example, you can connect to an SQL Server Database and Oracle Database both and can integrate the data into a third system.

The latest version of Informatica PowerCenter available is 9.6.0. The different editions for the PowerCenter are

Standard edition

Advanced edition

Premium edition

The popular clients using Informatica Powercenter as a data integration tool are U.S Air Force, Allianz, Fannie Mae, ING, Samsung, etc. The popular tools available in the market in competition to Informatica are IBM Datastage, Oracle OWB, Microsoft SSIS and Ab Initio.

OR

Define Informatica?

Ans: Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now days Informatica is also being used as an Integration tool.Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load.

These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.

Q2).Why do we need Informatica?

Ans: Informatica comes to the picture wherever we have a data system available and at the backend we want to perform certain operations on the data. It can be like cleaning up of data, modifying the data, etc. based on certain set of rules or simply loading of bulk data from one system to another.

Informatica offers a rich set of features like operations at row level on data, integration of data from multiple structured, semi-structured or unstructured systems, scheduling of data operation. It also has the feature of metadata, so the information about the process and data operations are also preserved.

Q3).What are the advantages of Informatica?

Ans: Informatica has some advantages over other data integration systems. A couple of the advantages are:

It is faster than the available platforms.

You can easily monitor your jobs with Informatica Workflow Monitor.

It has made data validation, iteration and project development to be easier than before.

If you experience failed jobs, it is easy to identify the failure and recover from it. The same applies to jobs that are running slowly.

Or

Its GUI tool, Coding in any graphical tool is generally faster than hand code scripting. Can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc). Can handle vary large/huge data very effectively. User can apply Mappings, extract rules, cleansing rules, transformation rules, aggregation logic and loading rules are in separate objects in an ETL tool. Any change in any of the object will give minimum impact of other object. Reusability of the object (Transformation Rules) Informatica has different “adapters” for extracting data from packaged ERP applications (such as SAP or PeopleSoft). Availability of resource in the market. Can be run on Window and Unix environment.

Q4).In what real situations can Informatica be used?

Ans: Informatica has a wide range of application that covers areas such as:

Data migration.

Application migration.

Data warehousing.

>>read more >>