Interview Questions.

Question 1. At The Time Of Informatica Powercenter Installation, Can You Please Let Us Know What All Components Are Installed?

Answer :

The following components are established at the same time as installing Informatica strength middle:

PowerCenter clients
Integration services
Repository provider
PowerCenter Domain
Administration console for PowerCenter
Question 2. What Is The Main Use Of Stored Procedure Transformation?

Answer :

The most important use of stored manner transformation is because it's miles a vital device for keeping and populating databases within the environment.

Informatica Interview Questions
Question 3. Explain What Is The Difference Between Static Cache And Dynamic Cache?

Answer :

Dynamic cache:

It decreases the overall performance and productiveness when compared to static cache

Static Cache:

Static cache is a manner wherein it simply inserts the data all of the time. It doesn’t count how normally the records is coming via, all it cares approximately is simply placing the information.

Question four. Explain Where We Can Find The Throughput Option In Informatica?

Answer :

The throughput alternative is determined in Informatica workflow display. Within the workflow monitor, right click at the session, then click at the run homes. Under supply/target information we will find the throughput alternative.

Informatica Tutorial
Question five. Define What Do You Mean By Worklet?

Answer :

A group of workflow obligations collected in a fixed is not anything however labeled as a “worklet”.

Within the workflow tasks, the subsequent are included:

Timer
Decision
Command
Event wait
Mail
Session
Link
Assignment
Control
Teradata Interview Questions
Question 6. What Is The Full Form Of Olap And Define What Is An Olap?

Answer :

OLAP stands for Online Analytical Processing. It is defined as a way wherein multidimensional evaluation takes place.

Question 7. Can You Name At Least One Alternative Tool For Scheduling Processes Other Than Workflow Manager?

Answer :

Control M is an opportunity tool for scheduling methods apart from workflow manager pmcmd.

Teradata Tutorial OBIEE Interview Questions
Question eight. What Are The Different Tools In Workflow Manager?

Answer :

The specific gear to be had in workflow manager are:

Task fashion designer
Task developer
Workflow fashion designer
Question 9. Define What Do You Mean By A Workflow?

Answer :

Workflow may be described as a fixed of commands which are intended to communicate to the server and letting it understand on the way to implement the obligations.

PL/SQL and Informatica Interview Questions
Question 10. Define What Is User-defined Event?

Answer :

A consumer-described occasion is not anything but a drift of tasks inside the workflow method. These events may be created and raised as on while there is a need related to it.

OBIEE Tutorial
Question 11. What Is A Predefined Event?

Answer :

As the call itself suggests that the event is predefined. It is nothing but a file watch occasion. Within this method, it'll look forward to a positive record to reach at a selected location.

Informatica MDM Interview Questions
Question 12. What Is The Use Of Standalone Command Task?

Answer :

The standalone command undertaking can be used anywhere inside a workflow technique to execute the shell instructions.

Informatica Interview Questions
Question thirteen. Define What Is A Session Task?

Answer :

A consultation project is defined as a bunch of instructions which might be guided closer to a power middle server which in the end defines whilst to transfer the information from supply to the objectives.

Question 14. What Are The Prerequisites Tasks That Are Needed To Achieve The Session Partition?

Answer :

If you need to do the session partition you then need to begin configuring the session to partition to source information after which you have to installation Informatica server machine in unique CPu. I.E. Multifold CPU’s.

Question 15. Define What Is A Surrogate Key?

Answer :

A surrogate secret's nothing but a substitute of the primary key in the database.
It is considered to be a completely unique identification factor for each row inside a desk.
It may be very useful due to the fact the number one key can alternate and accordingly makes it hard technique to update the facts, but no longer with the surrogate key.
A surrogate key is constantly within the form of a digit or an integer.
Informatica Admin Interview Questions
Question sixteen. What Does The Update Strategy Actually Mean And What Are The Different Options Available For It?

Answer :

Within Informatica, the facts is processed based on row by way of row.
Within the target desk, every row is inserted and it's miles marked as a default one.
The use of replace method is carried out best whilst there may be a need to update a unmarried row or insert a row based totally on a series defined.
Within the update approach, we want to say the condition so that the desired row in the replace approach can be processed and the row may be simply marked as in line with the circumstance, i.E. Updated or inserted.
Question 17. Can You Briefly Define What Is A Reusable Transformation?

Answer :

The reusable transformation concept is widely used in mappings.
Reusable transformation is special to that of different mappings where they use adjustments as it stores as a metadata.
Whenever there's a alternate inside the reusable transformation, the transformation might be nullified within the mappings.
Question 18. Define What Is A Mapplet?

Answer :

A mapplet is nothing but a recyclable item which makes use of a mapplet fashion designer.
Mapplet allows to reuse the transformation common sense in distinctive mappings.
A mapplet consists of a hard and fast of adjustments.
Teradata Interview Questions
Question 19. What Are The Types Of Loadings That Are Available In Informatica?

Answer :

In Informatica, they may be  types of loading:

Normal loading
Bulk loading
Normal loading is a procedure in which the records are loaded separately and it writes a log for the equal. When in comparison to other styles of loading regular loading the loading technique takes time to the goal supply.

Bulk loading is a system wherein a hard and fast of information are loaded into the target database without delay. When in comparison to ordinary loading method, bulk loading process takes very less time to load the statistics.

Question 20. Define What Is Aggregate Cache In Aggregator Transformation?

Answer :

The aggregator is nothing however a feature which shops all the records inside the aggregator cache until and except it offers with all of the combination calculations.  

So whilst you are executing a session in which you are the use of an aggregator transformation, the Informatica server will robotically start developing indexes and statistics caches inside the reminiscence to deal with and procedure the transformation.

It is a recognized reality that Informatica server desires greater space, it shops the overflow values in all the cache files.

Question 21. Explain What Is Meant By A Transformation? What Are The Different Types Of Transformations Available In Informatica?

Answer :

The term transformation itself depicts the character of the pastime. It is a repository item wherein it generates, modifies and passes the data.

The following are extraordinary styles of changes which can be available in Informatica:

Aggregator transformation
Expression transformation
Filter transformation
Joiner transformation
Lookup transformation
Normalizer transformation
Rank transformation
Router transformation
Question 22. What Is The Difference Between Active Transformations And A Passive Transformation In Informatica? Give Example Transformations For Each?

Answer :

Active transformation:

It is a manner it modifications the wide variety of rows that have long past through the mapping. This system is known as as Active transformation

Some of the Active adjustments are:

Sorter differences
Filter variations
Joiner transformations
Rank variations
Router transformations
etc.

Passive transformation:

It is a procedure wherein it doesn’t alternate the wide variety of rows that have long past through the mapping. This process is called as Passive transformation.

Some of the Passive adjustments are:

Expression transformation
Sequence Generator transformation
Lookup transformation
External method transformation
Output transformation
Input transformation
Etc.

Question 23. Explain What Is Target Load Order?

Answer :

Target load order is nothing but a listing of all sports where it is easy to define the concern. Based in this precedence the records might be loaded into the Informatica server.

If you have got a list of source qualifiers connected to multiple targets then you can outline the order or dictate an order to the Informatica server in order that the data can be loaded into the goals.

Question 24. Explain To Us Whether Two Flat Files Can Be Joined Together Using Joiner Transformation? Explain What Is Joiner Transformation Means?

Answer :

Yes, you may be a part of two flat documents collectively the usage of joiner transformation.

Joiner transformation is an energetic and connected transformation in which it is typically used to join two assets of statistics. The supply of statistics can be from one foundation or it could be from  one-of-a-kind origins

OBIEE Interview Questions
Question 25. What Are Different Types Of Dimensions That Are Available In Informatica?

Answer :

They are 3 sorts of dimensions which can be to be had:

Junk size
Degenerative measurement
Conformed dimension
Question 26. Explain What Are Slowly Changing Dimensions? What Are The Different Types Of Slowly Changing Dimensions That Are Available?

Answer :

Slow converting dimensions are the ones where the scale are intended to be changed in over the years. The sluggish changing dimensions are cited as SCD.

They are 3 different forms of slowly converting dimensions, they're:

Slowly changing size-Type 1:  In this sort of SCD it has simplest cutting-edge facts
Slowly changing dimension-Type 2:  In this type of SCD it has both present day statistics and additionally historic facts
Slowly converting measurement-Type three: In this type of SCD it has cutting-edge statistics plus one preceding document
Question 27. Explain What Is A Parameter File And Define What Are The Different Values That Are Available In A Parameter File?

Answer :

A parameter file is not anything however a file that is created in a text editor or a word pad.

The following specific values can be described in a parameter document, they're:

Mapping parameters
Mapping variables
Session parameters
PL/SQL and Informatica Interview Questions
Question 28. What Is A Connected Lookup?

Answer :

The connected research is a research which participates in all the information flows and it is capable of receiving inputs at once from the pipeline itself.
Within related lookup can be used within each dynamic cache and static cache.
Within related lookup, it caches all research columns
The linked lookup will aid consumer-defined values
Question 29. What Is An Unconnected Lookup?

Answer :

The unconnected research is entitled to get hold of input values from the result of LKP
With unconnected lookup, it could best go back one column price
The unconnected lookup does not absolutely support user-described default values
Question 30. What Is The Difference Between The Power Center Integration Service And The Data Integration Service?

Answer :

The Power Center Integration Service is an utility service that runs classes and workflows.

The Data Integration Service is an utility provider that plays statistics integration responsibilities for the Analyst tool,the Developer tool, and external clients. The Analyst tool and the Developer tool ship facts integration project requests to the Data Integration Service to preview or run data profiles, SQL records services, and mappings. Commands from the command line or an external customer send information integration undertaking requests to the Data Integration Service to run SQL information services or internet offerings.

Question 31. What Is The Difference Between The Powercenter Repository Service And The Model Repository Service?

Answer :

The PowerCenter utility services and PowerCenter software customers use the PowerCenter Repository Service. The PowerCenter repository has folder-based totally security.

The different utility services, which include the Data Integration Service, Analyst Service, Developer tool, and Analyst tool, use the Model Repository Service. The Model Repository Service has challenge-primarily based security.

You can migrate a few Model repository objects to the PowerCenter repository.

Question 32. What Is The Difference Between A Mapplet In Powercenter And A Mapplet In The Developer Tool?

Answer :

Mapplet in PowerCenter and within the Developer device is a reusable item that contains a hard and fast of modifications. You can reuse the transformation logic in more than one mappings. 
PowerCenter mapplet can incorporate source definitions or Input transformations because the mapplet input.  It need to comprise Output differences as the mapplet output. 
Developer device mapplet can comprise records items or Input variations because the mapplet enter.  It can include data items or Output changes as the mapplet output. 
A mapping inside the Developer device also consists of the following capabilities:

You can validate a mapplet in most cases. 
You use a rule in a profile. 
A mapplet can incorporate other mapplets. 
Question 33. What Is The Difference Between A Mapplet And A Rule?

Answer :

You can validate a mapplet as a rule. A rule is enterprise logic that defines situations applied to supply information while you run a profile.

You can validate a mapplet as a rule while the mapplet meets the subsequent necessities:

It includes an Input and Output transformation. 
The mapplet does now not contain lively adjustments. 
It does not specify cardinality between enter organizations.
Informatica MDM Interview Questions
Question 34. What Is The Difference Between A Source And Target In Powercenter And A Physical Data Object In The Developer Tool?

Answer :

In PowerCenter, you create a supply definition to include as a mapping source. You create a goal definition to consist of as a mapping target. In the Developer device, you create a physical statistics object that you can use as a mapping source or target.