Tag Archives: informatica tutorial

Why to Choose Informatica MDM in an Organizations?


Master Data Management (MDM) is used for a wide range of business management. As every organization faces consistent changes including process of reporting, software changes etc., it is very difficult to support the business growth. MDM tool introduces the basic methods that can be followed to achieve the targets. The processes involved in MDM, provide the following benefits to the business:

  • Management style
  • Governance
  • Organizational structure
  • Collaborating the programs across different departments
  • Ensure safety and security
  • Supporting the change

Reasons for an organization to choose Informatica MDM tool:

One of the most important tools that the company prefer is the MDM. This tool integrates functionalities that lead the company to be successful. It addresses the responsibilities of the business problems and ensures to select the right vendor.

  • MDM tool provides reference to critical information
  • It ensures customer contact information
  • Multiple sources of ideas and information
  • Conflicting sources of varied resources
  • Assures success and the growth of business

As Informatica MDM provides proper data engagement, data enrichment and the quality services to data, it meets the needs of the organization. This also provides information that serves as the magical quadrant of the extensive research. Some business leads can start a small business and grow rapidly.

Types of master data in MDM:

Master data tool especially manages the information that is identified as meta-data. There are five types of data management.

  1. Meta-data: This kind of data is found in formal repository as XML, databases, column description etc.
  2. Unstructured: The unstructured data is found in white papers, intranet, marketing, and pdf files.
  3. Master: These are critical elements that fall directly under domain areas, subject areas and in concepts.
  4. Transactional: It is related to the invoices, delivery, transactions, application processing etc.
  5. Hierarchical: It provides relationship between one data to another. It has good understanding of the sequential flow of the business process.

Process of MDM that is involved in the growth of business:

There are many purposes for a company to choose MDM. It defines the technology, process, tools used with the accurate list of master data. It performs master clean to keep the data consistent and updated. It influences priorities, availability of resources, deals, analysis etc. The below mentioned process is carried out by the tool.

  1. Identification of the master data resources
  2. Identification of producer and consumer
  3. Analyse metadata about master data
  4. Determining the method to transform resources
  5. Implementation of data governance council and program
  6. Developing a model for metadata
  7. Choosing the corresponding toolset
  8. Designing the infrastructure
  9. Iterative process of testing
  10. Modification as per the consumption

Organizations with highly distributed businesses frequently involve in large-scale activities. This deals with a wide range of reaching the data integration challenges that are designed to mitigate the time and value spent.

For Informatica Training needs, Visit  http://www.zarantech.com/course-list/informatica-training. Call 515-309-7846 or email  info@zarantech.com.

Worthwhile Inputs for preparing for the Informatica Certification


Informatica in PowerCenter space offers two different certification courses. One for the Developers and the other one for the Admin.

Part 1: The Syllabus and the Materials that cover the Syllabus

The Certification aims at providing you with good insights on PowerCenter Installation, Configuration, Transformations, and proven best practices in Project Implementation. This Certificate prepares you to successfully use Informatica to import sources, targets, and lookups, for creating slowly changing dimension mappings as best practices, and to create reusable transformations and Mapplets. You will also need to show your ability to execute reusability through shortcuts, for successfully using the debugger to debug a mapping either with or without a prebuilt session, flow of work, incorporation and supervision of the session.

When you are attempting the test, you will be tested on the following parameters:

  • Mapping Design Basic
  • Mapping Design Advanced
  • Parameters and Variables
  • Transformation Language
  • Troubleshooting
  • Workflows and Worklets
  • Architecture & Administration

The skills and knowledge, which will be scaled during this exam include execution of project based on the core product functionality. The course includes training materials, support documentation, and practical hands on.

Part 2: Pre-requisite for taking up the course

In order to make the most out of the course, to the best of your knowledge, skills, and ability, the following pre-requisites, which are also the courses on Informatica, needs to be completed.  

  • Informatica 9.x PowerCenter Developer Level 1.
  • Informatica 9.x PowerCenter Developer Level 2.

Part 3: The Informatica Certified Professional Program

In order to harness the knowledge, skills, and capabilities you already possess, for taking up data integration and data quality projects, you will need to update the certification, on a timely basis. Only then you will be realizing the return on your investment towards the certification, in a faster and a better manner. Also, it will help you to stand out in the cutthroat competitive crowd in the job market.

Levels of Certification

The Informatica Professional Certification Program requires completion of three levels of certification, which includes,

  1. Specialist
  2. Expert
  3. Master

A candidate shall get certified based on his/her knowledge about the product, experience in the respective field, and ability to follow the best practices for velocity implementation methodology. Completion of test and getting certified as the Informatica Professional provides enormous benefits to the candidate. It is a proctored, cost effective, lab-based exam that can be taken anywhere and anytime.

In summary

  • The test comprises of 70 multiple choice/multiple response/true-false based questions.
  • The questions are thrown on 7 broad topics of Informatica PowerCenter product.
  • The minimum requirement to get certified as Informatica PowerCenter Data Integration 9.X: Developer of Specialist status is 70%.

The following are the broad topics of Informatica Power Center Product, on which the questions will be asked. The table also shows the weight age for each of the broad topics covered in the exam.


The main point to be noted is, there is no alternate for practical hands on experience, and thus, it is highly recommended that you thoroughly get used to different transformations and concepts on the PowerCenter tools.

Setting the complete introduction aside, let us now straight away look into the actual topic.

The main question which arises in a candidate’s mind is which are the materials I should be referring to are and what are the topics which I have to prepare?

Part 4: The reading materials that need to be downloaded

The product guides, which come along with the product installation package is the primary source of reading material.

The access to this site can be got if you own an email ID of a corporation, which is an official partner of Informatica.

If you are unable to get access, then, you may try looking out for pdf files separately on Google for download from their links as displayed by the Google. The links will be only from the Informatica Community website. Any 9.x.x version guide will be sufficient for a thorough preparation.

 The following are the 7 guides, which are mandatory for preparation:


If you do not have access to Informatica portal, or if you are not in a position to get an access, then, see that you search for them on Google and download them separately.

Part 5:-Which are the required chapters to study?

Vowing to the reason that the syllabus is vast, and it is highly difficult for you to be thorough on every topic equally, for your convenience, the following tables’ throw insights on the weight age for each topic from the syllabus. It also includes the chapters from the guides that you are required to study.

Mapping Design Basics: – 45%


Mapping Design Advanced: – 20%


Others: – 35%


The aforesaid ones are the actual reading materials and chapters that need to be covered in your study, in order to pass the test and obtain the Certification.

Hope we have done a good job in giving you enough information, for helping you become a Pro in Informatica in PowerCenter.

For further details on the fee for the exam and scheduling an appointment for the exam, you may visit here.



Informatica- Redefinition of data industry

Informatica--Redefinition-of-data-industryThroughout the years we’ve generally attempted to better characterize the ROI of information reconciliation. It appears to be really straightforward. There is an expanding worth to center endeavor frameworks and information stores once they correspond viably with other venture frameworks and information stores. There is undiscovered worth when frameworks and stores don’t trade information.

Continue reading Informatica- Redefinition of data industry

New features in Informatica

InformaticaInformatica nine empowers line-of-business managers and business analysts to spot unhealthy knowledge and fix it quicker. Design wise there aren’t any variations between Informatica eight and nine however there are a unit some new options added in power center nine.

Continue reading New features in Informatica

What is ETL in Informatica?

ETL in InformaticaInformatica ETL is business pioneer in information combination and information quality administrations. Informatica is fruitful ETL and EAI tool with critical industry scope. ETL refers to extract, transform, load. Information coordination tools are not quite the same as other programming stages. They have no inbuilt component to fabricate client interface where end client can see the changed information. Informatica ETL “force focus” has capacity to oversee, coordinate and relocate undertaking information.

Continue reading What is ETL in Informatica?

Informatica Best practices:

  1. InformaticaLookup

What do you mean by lookup transformation? Lookup transformations should fetch data that will look against the source data. It is useful when used effectively. If not used effectively performance mapping is impaired. These are the problems with Lookup and we can resolve it in the following ways:

Continue reading Informatica Best practices: