Informatica Interview Questions

Name: Informatica Interview Questions
Address: Atlanta, GA, US
Telephone: +1 770-777-1269

Home
United States
Atlanta, GA
Informatica Interview Questions

Informatica Interview Questions and Answers from H2kinfosys.com

07/11/2018

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

05/04/2018

provided by Outstanding Trainers,

Interactive Live with Continuous Access 24/7,

100% Oriented Training.

Call: 678-919-1990

Visit: https://goo.gl/HQYCpg

03/31/2018

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.

03/30/2018

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.

03/29/2018

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.

03/28/2018

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.

03/27/2018

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

03/24/2018

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.

03/23/2018

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.

03/22/2018

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.

03/21/2018

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.

Address

Atlanta, GA

Telephone

+1 770-777-1269

Website

https://www.h2kinfosys.com/courses/informatica-online-training-course-details

Alerts

Be the first to know and let us send you an email when Informatica Interview Questions posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Want your business to be the top-listed Computer & Electronics Service in Atlanta?