Informatica Data Quality Interview Questions & Answers

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 installed while installing Informatica power center:

1. PowerCenter clients
2. Integration services
3. Repository service
4. PowerCenter Domain
5. Administration console for PowerCenter

Question 2. What Is The Main Use Of Stored Procedure Transformation?

Answer :

The main use of stored procedure transformation is because it is a vital tool for maintaining and populating databases within the environment.

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

Answer :

Dynamic cache:

It decreases the performance and productivity when compared to static cache

Static Cache:

Static cache is a process where it just inserts the data all the time. It doesn’t matter how many times the data is coming through, all it cares about is just inserting the data.

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

Answer :

The throughput option is found in Informatica workflow monitor. Within the workflow monitor, right click on the session, then click on the run properties. Under source/target statistics we can find the throughput option.

Question 5. Define What Do You Mean By Worklet?

Answer :

A group of workflow tasks accumulated in a set is nothing but classified as a “worklet”.

Within the workflow tasks, the following are included:

1. Timer
2. Decision
3. Command
4. Event wait
5. Mail
6. Session
7. Link
8. Assignment
9. Control

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 method in which multidimensional analysis occurs.

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

Answer :

Control M is an alternative tool for scheduling processes other than workflow manager pmcmd.

Question 8. What Are The Different Tools In Workflow Manager?

Answer :

The different tools available in workflow manager are:

1. Task designer
2. Task developer
3. Workflow designer

Question 9. Define What Do You Mean By A Workflow?

Answer :

Workflow can be defined as a set of instructions which are intended to communicate to the server and letting it know on how to implement the tasks.

Question 10. Define What Is User-defined Event?

Answer :

A user-defined event is nothing but a flow of tasks in the workflow process. These events can be created and raised as on when there is a need associated with it.

Question 11. What Is A Predefined Event?

Answer :

As the name itself suggests that the event is predefined. It is nothing but a file watch event. Within this process, it will wait for a certain file to arrive at a specific location.

Question 12. What Is The Use Of Standalone Command Task?

Answer :

The standalone command task can be used anywhere within a workflow process to execute the shell commands.

Question 13. Define What Is A Session Task?

Answer :

A session task is defined as a bunch of instructions which are guided towards a power center server which ultimately defines when to transfer the data from source to the targets.

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

Answer :

If you have to do the session partition then you need to start configuring the session to partition to source data and then you have to install Informatica server machine in different CPu. I.e. multifold CPU’s.

Question 15. Define What Is A Surrogate Key?

Answer :

• A surrogate key is nothing but a replacement of the primary key within the database.
• It is considered to be a unique identification factor for each row within a table.
• It is very helpful because the primary key can change and thus makes it difficult process to update the data, but not with the surrogate key.
• A surrogate key is always in the form of a digit or an integer.

Question 16. What Does The Update Strategy Actually Mean And What Are The Different Options Available For It?

Answer :

• Within Informatica, the data is processed based on row by row.
• Within the target table, every row is inserted and it is marked as a default one.
• The use of update strategy is done only when there is a need to update a single row or insert a row based on a sequence defined.
• Within the update strategy, we need to mention the condition so that the specified row in the update strategy can be processed and the row can be actually marked as per the condition, 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 different to that of other mappings where they use transformations as it stores as a metadata.
• Whenever there is a change in the reusable transformation, the transformation will be nullified in the mappings.

Question 18. Define What Is A Mapplet?

Answer :

• A mapplet is nothing but a recyclable object which uses a mapplet designer.
• Mapplet permits to reuse the transformation logic in different mappings.
• A mapplet consists of a set of transformations.

Question 19. What Are The Types Of Loadings That Are Available In Informatica?

Answer :

In Informatica, they are two types of loading:

1. Normal loading
2. Bulk loading

Normal loading is a process where the records are loaded one by one and it writes a log for the same. When compared to other types of loading normal loading the loading process takes time to the target source.

Bulk loading is a process where a set of records are loaded into the target database at once. When compared to normal loading process, bulk loading process takes very less time to load the data.

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

Answer :

The aggregator is nothing but a function which stores all the data in the aggregator cache until and unless it deals with all the aggregate calculations.  

So when you are executing a session in which you are using an aggregator transformation, the Informatica server will automatically start creating indexes and data caches in the memory to accommodate and process the transformation.

It is a known fact that Informatica server needs more space, it stores 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 nature of the activity. It is a repository object where it generates, modifies and passes the data.

The following are different types of transformations that are available in Informatica:

1. Aggregator transformation
2. Expression transformation
3. Filter transformation
4. Joiner transformation
5. Lookup transformation
6. Normalizer transformation
7. Rank transformation
8. 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 process it changes the number of rows that have gone through the mapping. This process is called as Active transformation

Some of the Active transformations are:

• Sorter transformations
• Filter transformations
• Joiner transformations
• Rank transformations
• Router transformations

etc.

Passive transformation:

It is a process where it doesn’t change the number of rows that have gone through the mapping. This process is called as Passive transformation.

Some of the Passive transformations are:

• Expression transformation
• Sequence Generator transformation
• Lookup transformation
• External procedure transformation
• Output transformation
• Input transformation

Etc.

Question 23. Explain What Is Target Load Order?

Answer :

Target load order is nothing but a list of all activities where one can define the priority. Based on this priority the data will be loaded into the Informatica server.

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

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 can join two flat files together using joiner transformation.

Joiner transformation is an active and connected transformation where it is primarily used to join two sources of data. The source of data can be from one origin or it can be from two different origins

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

Answer :

They are three types of dimensions that are available:

1. Junk dimension
2. Degenerative dimension
3. Conformed dimension

Question 26. Explain What Are Slowly Changing Dimensions? What Are The Different Types Of Slowly Changing Dimensions That Are Available?

Answer :

Slow changing dimensions are those where the dimensions are meant to be changed in over time. The slow changing dimensions are noted as SCD.

They are three different types of slowly changing dimensions, they are:

1. Slowly changing dimension-Type 1:  In this type of SCD it has only current records
2. Slowly changing dimension-Type 2:  In this type of SCD it has both current records and also historical records
3. Slowly changing dimension-Type 3: In this type of SCD it has current records plus one previous record

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 nothing but a file which is created in a text editor or a word pad.

The following different values can be defined in a parameter file, they are:

1. Mapping parameters
2. Mapping variables
3. Session parameters

Question 28. What Is A Connected Lookup?

Answer :

1. The connected lookup is a lookup which participates in all the data flows and it is capable of receiving inputs directly from the pipeline itself.
2. Within connected lookup can be used within both dynamic cache and static cache.
3. Within connected lookup, it caches all lookup columns
4. The connected lookup will support user-defined values

Question 29. What Is An Unconnected Lookup?

Answer :

• The unconnected lookup is entitled to receive input values from the result of LKP
• With unconnected lookup, it can only return one column value
• The unconnected lookup does not really support user-defined 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 application service that runs sessions and workflows.

The Data Integration Service is an application service that performs data integration tasks for the Analyst tool,the Developer tool, and external clients. The Analyst tool and the Developer tool send data integration task requests to the Data Integration Service to preview or run data profiles, SQL data services, and mappings. Commands from the command line or an external client send data integration task requests to the Data Integration Service to run SQL data services or web services.

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

Answer :

The PowerCenter application services and PowerCenter application clients use the PowerCenter Repository Service. The PowerCenter repository has folder-based security.

The other application services, such as the Data Integration Service, Analyst Service, Developer tool, and Analyst tool, use the Model Repository Service. The Model Repository Service has project-based security.

You can migrate some 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 :

1. Mapplet in PowerCenter and in the Developer tool is a reusable object that contains a set of transformations. You can reuse the transformation logic in multiple mappings. 
2. PowerCenter mapplet can contain source definitions or Input transformations as the mapplet input.  It must contain Output transformations as the mapplet output. 
3. Developer tool mapplet can contain data objects or Input transformations as the mapplet input.  It can contain data objects or Output transformations as the mapplet output. 

A mapping in the Developer tool also includes the following features:

1. You can validate a mapplet as a rule. 
2. You use a rule in a profile. 
3. A mapplet can contain 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 business logic that defines conditions applied to source data when you run a profile.

You can validate a mapplet as a rule when the mapplet meets the following requirements:

1. It contains an Input and Output transformation. 
2. The mapplet does not contain active transformations. 
3. It does not specify cardinality between input groups.

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 source definition to include as a mapping source. You create a target definition to include as a mapping target. In the Developer tool, you create a physical data object that you can use as a mapping source or target.