Informatica Interview Questions

Dreaming about your ?

you are at right place!

is designed by the current and future emerging trends in the world of .

Learn Informatica by our .

Call: 770-777-1269

provided by Outstanding Trainers,

Interactive Live with Continuous Access 24/7,

100% Oriented Training.

Call: 678-919-1990

Visit: https://goo.gl/HQYCpg

Q: Mention few Test cases and explain them.

Mapping Doc Validation – Verifying if the ETL information is provided in the Mapping Doc.

Data Check – Every aspect regarding the Data such as Data check, Number Check, Null check are tested in this case

Correctness Issues – Misspelled Data, Inaccurate data and null data are tested.

Q: Explain ETL Mapping Sheets.

ETL mapping sheets contains all the required information from the source file including all the rows and columns. This sheet helps the experts in writing the SQL queries for the ETL tools testing.

Q: Differentiate between a database, and data warehouse?

Database have a group of useful information which is brief in size as compared to data warehouse whereas in data warehouse their are set of every kind of data whether it is useful or not and data is extracted as the the requirement of customer.

Q: Compose the benefits of parceling a session?

The principle preferred standpoint of dividing a session is to show signs of improvement server’s procedure and fitness. Other favorable position is it executes the performance successions inside the session.

Q: How to elaborate Tracing Level?

Tracing Level can be defined as the amount of information that the server writes in the log file. Tracing Level is created and configured either at the transformation level or at session level else at both the levels.

Given below are the 4 types of tracing level:

> None
> Terse
> Verbose Initialization
> Verbose Data

Q: What is the utilization of gathering store record?

In the event that additional memory is required gathering gives additional reserve documents to keeping the change appreciates. It additionally keeps the transitional appreciate that are there in nearby cradle memory.

Q: Where The Data Cube Technology is Used?

A multi-dimensional structure called the data cube. A data abstraction allows one to view aggregated data from a number of perspectives. Conceptually, the cube consists of a core or base cuboids, surrounded by a collection of sub-cubes/cuboids that represent the aggregation of the base cuboids along one or more dimensions. We refer to the dimension to be aggregated as the measure attribute, while the remaining dimensions are known as the feature attributes.

Q: Characterize client resisted occasion?

Client characterized occasion are a stream of tasks in the work process. Occasions can be produced and after that raised as need comes.

Q: How does the recovery mode work in informatica?

In case of load failure an entry is made in OPB_SERV_ENTRY(?) table from where the extent of loading can be determined.