informatica edc interview questions

• What do you mean by Enterprise data warehouse? …
• What is ETL (Extract, transform, Load) and write some ETL tools. …
• What is Informatica PowerCenter? …
• Name different types of transformation that are important? …
• Write the difference between connected lookup and unconnected lookup.

In this Informatica interview questions list, you will come to know the top questions asked in the Informatica job interview. You will learn the difference between a database and a data warehouse, Informatica Workflow Manager, mapping parameter vs mapping variable, and more. Learn Informatica from Intellipaat Informatica Certification Course and fast-track your career!

Introduction to Introduction Informatica EDC (Enterprise Data Catalog) and Informatica Axon

Top 10 Informatica Interview Questions

Want to enhance your career and become a professional in Informatica, then enroll in “Informatica Training”. This course will help you to achieve excellence in this domain.

Best Informatica Interview Questions and Answers

This Informatica Interview Questions blog covers all the core concepts from basic to advanced level. So utilize these Questions to improve your chances of being hired in your next interview!

What the difference is between a database, a data warehouse and a data mart?

Database includes a set of sensibly affiliated data which is normally small in size as compared to data warehouse. While in data warehouse there are assortments of all sorts of data and data is taken out only according to the customer’s needs. On the other hand datamart is also a set of data which is designed to cater the needs of different domains. For instance an organization having different chunk of data for its different departments i.e. sales, finance, marketing etc.

Most Frequently Asked Informatica Interview Questions

Let us have a quick review of the Informatica interview questions.

Ans: INFORMATICA is a product advancement firm that offers various information incorporation solutions for ETL, information virtualization, ace information the executives, information quality, information imitation, ultra informing, and so forth.

Want to Become a Master in Informatica? Then visit here to Learn Informatica Training

A portion of the well-known INFORMATICA items are:

The IT community needs INFORMATICA while working with information frameworks that contain information to play out specific activities alongside a lot of rules. It encourages tasks line cleaning and altering information from organized and unstructured information frameworks.

Ans:

Database:

It includes a set of sensible data. This affiliated data is normally small in size as compared to a data warehouse.

Data Warehouse:

It includes the assortments of all sorts of data. The data is taken out only according to the customers needs.

Datamart:

It is also a set of data which is designed to cater to the needs of different domains. For instance, an organization having a different chunk of data for its different departments i.e. sales, finance, marketing etc.

Ans:

Informatica lookups can be cached or uncached.

Cached lookups can be either static or dynamic.

A lookup cache can also be divided as persistent or non-persistent based on whether Informatica retains the cache even after completing session run or if it deletes it.

Different lookup caches are.

Static cache

Dynamic cache

Persistent cache

Shared cache

Recache

Ans: The various components of the Informatica PowerCenter are

Ans: If you run the session in the time stamp mode then automatically session log out will not overwrite the current session log.

Go to Session Properties –> Config Object –> Log Options

Select the properties as follows:

Save session log by –> SessionRuns.

Save session log for these runs –> Change the number that you want to save the number of log files (Default is 0).

If you want to save all of the log files created by every run, and then select the option Save session log for these runs –> Session TimeStamp. You can find these properties in the session/workflow Properties.

Get ahead in your career by learning Informatica course through hkrtrainings Informatica Training in Hyderbad !

Ans:

Mapping:

It is a collection of source, target and transformation.

It is developed with different transformations and is not reusable.

It is developed around what data to move the target and what modification is performed on it.

Mapplet:

It is a collection of transformation only.

It can be reused with other mapping and also mapplets.

It is developed for complex calculations used in multiple mappings.

Ans:

Command tasks at session-level are used to create the indexes after the load process.

Index creating scripts can be brought in line with the sessions workflow or the post-session implementation sequence.

This type of index creation cannot be controlled after the load process at the transformation level.

Ans: Enterprise Data Warehousing is about organizing the data that can be created or developed at a single point of access. The data is globally accessed and viewed through a single source as the server is linked to a single source. Enterprise data warehousing also includes the periodic analysis of the source.

We have the perfect professional Informatica Tutorial for you. Enroll now!

Ans:

A session is a teaching set that is implemented to convert data from a source to a target. Sessions manager is used to carry out a session or by using the “pmcmd” command.

Batch execution can be used to combine sessions executions either in a serial manner or in a parallel. Batches can have different sessions carrying forward in a parallel or serial manner.

Ans:

Mapping variable:

Mapping variables are the values which change during the session’s execution.

After completion, the Informatica server stores the end value of a variable and is reused when session restarts.

Mapping parameter:

Mapping parameters are the values which do not change during the session execution.

Mapping procedure explains mapping parameters and their usage. Values are allocated to these parameters before starting the session.

Master Your Craft

Lifetime LMS & Faculty Access

24/7 online expert support

Real-world & Project Based Learning

Ans: The different mapping design tips are as follows.

1. Standards: The design should be of a good standard. Long run projects are proven to have consistent standards. These standards include naming descriptions, conventions, environmental settings, documentation and parameter files etc.
2. Reusability: Using reusable transformation is the best way to react to the potential changes as quickly as possible. Mapplets and worklets are the two best-suited types of Informatica components which can be used.
3. Scalability: It is crucial to scale while designing. In the development of mappings, the volume must be correct.
4. Simplicity: It is always better to create different mappings instead of creating one complex mapping. Simplicity all about creating a simple and logical process of designing.
5. Modularity: This includes reprocessing and using modular techniques for designing.

Ans: Power Centre repository of Informatica consists of the following metadata.

Source Definition

Session and session logs

Workflow

Target Definition

Mapping

ODBC Connection

There are two repositories as follows.

Global Repositories

Local Repositories

Mainly Extraction, Loading (ETL) and Transformation of this metadata are performed through the Power Centre Repository.

Ans: Repository Manager is GVI based administrative client which allows performing the following administrative tasks:

Creating, editing and deleting the folders.

Assigning access permissions such as read, write and execute to users for accessing folders.

Backup and Restore repository objects.

Ans: Workflow Manager is a GUI based client which allows creating the ELT objects as follows.

Session:

It is a task that executes mapping.

It is created for each Mapping.

It is created to provide runtime properties.

It is a set of instructions that tells ETL server to move the data from source to destination.

Workflow:

It is a set of instructions that tells how to run the session tasks and when to run the session tasks

Scheduler:

A scheduler is an automation process which runs the workflow at a given date and time.

Ans:

Informatica PowerCenter is an integration tool which combines the data from multiple OLTP source systems and transforms the data into a homogeneous format to deliver the data throughout the enterprise at any speed.

It is a GUI based ETL product from Informatica corporation which was founded in the year 1993 at Redwood City, California.

There are many products in Informatica corporation as follows:

Informatica Analyzer.

Life cycle management.

Master data.

Ans: There are two ways to filter rows in Informatica.

It filters rows while reading data from a relational data source.

It minimizes the number of rows while mapping to enhance the performance.

Standard SQL is used by the filter condition for executing in the database.

It filters rows within a mapped data from any source.

It is added close to the source to filter out the unwanted data and maximize the performance.

It generates true or false values based on conditions.

Ans:

Joiner:

It is not possible to override the query.

Only the ‘=’ operator is available.

Users can’t restrict the number of rows while reading relational tables.

Tables are joined using Joins.

Lookup:

It is possible to override the query.

All operators are available for use.

Users can restrict the number of rows while reading relational tables.

It behaves as Left Outer Join while connecting with the database.

FAQ

What is Informatica EDC?

How can I prepare for Informatica interview?

1. What are the advantages of Informatica over other ETL tools? …
2. What are the main components of Informatica? …
3. What can Informatica be used for in an organization? …
4. What is an enterprise data warehouse? …
5. Describe an Informatica workflow. …
6. What is the domain?

What is the difference between EDC and Axon?

How do I get last 3 records in Informatica?

1. You can associate the records from filw with a seq.
2. Sort it based on seq (descending)
3. Count till you send the first three records into target, filter the others.