Top 34 Informatica Data Quality Interview Questions
Q1. What Is The Difference Between Active Trformations And A Passive Trformation In Informatica? Give Example Trformations For Each?
Active trformation:
It is a manner it adjustments the quantity of rows which have gone via the mapping. This method is known as as Active trformation
Some of the Active trformations are:
Sorter trformations
Filter trformations
Joiner trformations
Rank trformations
Router trformations
and many others.
Passive trformation:
It is a manner where it doesn’t exchange the wide variety of rows that have gone thru the mapping. This system is referred to as as Passive trformation.
Some of the Passive trformations are:
Expression trformation
Sequence Generator trformation
Lookup trformation
External method trformation
Output trformation
Input trformation
Etc.
Q2. Explain To Us Whether Two Flat Files Can Be Joined Together Using Joiner Trformation? Explain What Is Joiner Trformation Me?
Yes, you could be a part of flat files collectively the use of joiner trformation.
Joiner trformation is an active and related trformation in which it's far ordinarily used to sign up for two sources of facts. The source of information can be from one origin or it can be from two distinctive origins
Q3. What Is The Main Use Of Stored Procedure Trformation?
The primary use of saved system trformation is because it's far a important device for preserving and populating databases inside the environment.
Q4. What Is The Difference Between A Mapplet And A Rule?
You can validate a mapplet most likely. A rule is commercial enterprise good judgment that defines conditions carried out to supply information when you run a profile.
You can validate a mapplet regularly when the mapplet meets the following requirements:
It carries an Input and Output trformation.
The mapplet does not comprise lively trformations.
It does no longer specify cardinality between input businesses.
Q5. What Is The Difference Between The Power Center Integration Service And The Data Integration Service?
The Power Center Integration Service is an application service that runs classes and workflows.
The Data Integration Service is an software provider that plays facts integration tasks for the Analyst tool,the Developer tool, and external customers. The Analyst device and the Developer device ship facts integration undertaking requests to the Data Integration Service to preview or run statistics profiles, SQL statistics services, and mappings. Commands from the command line or an external patron send data integration mission requests to the Data Integration Service to run SQL information offerings or internet services.
Q6. What Are Different Types Of Dimensions That Are Available In Informatica?
They are 3 forms of dimensions that are to be had:
Junk size
Degenerative size
Conformed dimension
Q7. Define What Do You Mean By Worklet?
A group of workflow tasks gathered in a hard and fast is nothing but classified as a “worklet”.
Within the workflow duties, the subsequent are blanketed:
Timer
Decision
Command
Event wait
Session
Link
Assignment
Control
Q8. Explain Where We Can Find The Throughput Option In Informatica?
The throughput option is located in Informatica workflow monitor. Within the workflow display, right click on at the session, then click on at the run homes. Under supply/goal facts we can discover the throughput choice.
Q9. What Is The Difference Between The Powercenter Repository Service And The Model Repository Service?
The PowerCenter software offerings and PowerCenter utility customers use the PowerCenter Repository Service. The PowerCenter repository has folder-based security.
The different utility services, together with the Data Integration Service, Analyst Service, Developer tool, and Analyst tool, use the Model Repository Service. The Model Repository Service has mission-primarily based safety.
You can migrate a few Model repository items to the PowerCenter repository.
Q10. What Is The Difference Between A Source And Target In Powercenter And A Physical Data Object In The Developer Tool?
In PowerCenter, you create a source definition to include as a mapping source. You create a target definition to consist of as a mapping goal. In the Developer tool, you create a physical statistics object that you could use as a mapping source or target.
Q11. Define What Is Aggregate Cache In Aggregator Trformation?
The aggregator is not anything however a characteristic which shops all the data inside the aggregator cache until and except it offers with all the combination calculations.
So while you are executing a session in which you are the use of an aggregator trformation, the Informatica server will robotically begin creating indexes and records caches inside the memory to deal with and technique the trformation.
It is a acknowledged reality that Informatica server needs extra area, it shops the overflow values in all the cache files.
Q12. What Is The Difference Between A Mapplet In Powercenter And A Mapplet In The Developer Tool?
Mapplet in PowerCenter and inside the Developer tool is a reusable item that consists of a hard and fast of trformations. You can reuse the trformation common sense in multiple mappings.
PowerCenter mapplet can incorporate supply definitions or Input trformations because the mapplet input. It should contain Output trformations because the mapplet output.
Developer device mapplet can contain information gadgets or Input trformations because the mapplet input. It can contain facts objects or Output trformations because the mapplet output.
A mapping within the Developer device additionally includes the subsequent capabilities:
You can validate a mapplet more often than not.
You use a rule in a profile.
A mapplet can incorporate other mapplets.
Q13. Explain What Is The Difference Between Static Cache And Dynamic Cache?
Dynamic cache:
It decreases the overall performance and productivity while compared to static cache
Static Cache:
Static cache is a system in which it simply inserts the statistics all of the time. It doesn’t rely how frequently the facts is coming through, all it cares about is simply putting the facts.
Q14. Can You Briefly Define What Is A Reusable Trformation?
The reusable trformation concept is extensively utilized in mappings.
Reusable trformation is one-of-a-kind to that of different mappings in which they use trformations because it shops as a metadata.
Whenever there may be a exchange within the reusable trformation, the trformation can be nullified inside the mappings.
Q15. What Are The Prerequisites Tasks That Are Needed To Achieve The Session Partition?
If you need to do the session partition you then need to begin configuring the session to partition to source facts after which you have to set up Informatica server device in special CPu. I.E. Multifold CPU’s.
Q16. Explain What Is Target Load Order?
Target load order is not anything but a list of all activities where you can actually outline the priority. Based on this precedence the information may be loaded into the Informatica server.
If you have a list of supply qualifiers related to multiple targets then you may define the order or dictate an order to the Informatica server so that the statistics can be loaded into the targets.
Q17. What Is The Full Form Of Olap And Define What Is An Olap?
OLAP stands for Online Analytical Processing. It is described as a technique wherein multidimensional evaluation happens.
Q18. What Are The Different Tools In Workflow Manager?
The different equipment to be had in workflow supervisor are:
Task dressmaker
Task developer
Workflow clothier
Q19. What Is A Predefined Event?
As the call itself indicates that the event is predefined. It is not anything but a report watch event. Within this technique, it'll wait for a positive document to arrive at a selected area.
Q20. Define What Is User-described Event?
A person-described occasion is not anything however a flow of tasks inside the workflow process. These activities may be created and raised as on while there's a want related to it.
Q21. Define What Is A Surrogate Key?
A surrogate key is nothing however a replacement of the number one key inside the database.
It is taken into consideration to be a unique identity thing for each row within a desk.
It may be very beneficial due to the fact the primary key can change and therefore makes it hard procedure to update the statistics, however not with the surrogate key.
A surrogate key's constantly within the shape of a digit or an integer.
Q22. What Is A Connected Lookup?
The connected research is a lookup which participates in all the records flows and it's far able to receiving inputs immediately from the pipeline itself.
Within connected lookup may be used within each dynamic cache and static cache.
Within connected research, it caches all lookup columns
The connected research will assist person-described values
Q23. Can You Name At Least One Alternative Tool For Scheduling Processes Other Than Workflow Manager?
Control M is an opportunity device for scheduling methods aside from workflow supervisor pmcmd.
Q24. Define What Is A Session Task?
A session venture is defined as a group of instructions which might be guided in the direction of a energy center server which in the end defines when to trfer the records from source to the targets.
Q25. What Does The Update Strategy Actually Mean And What Are The Different Options Available For It?
Within Informatica, the data is processed based totally on row by way of row.
Within the goal desk, each row is inserted and it is marked as a default one.
The use of update strategy is finished best when there's a want to update a single row or insert a row primarily based on a chain defined.
Within the replace strategy, we need to say the circumstance in order that the specified row within the replace strategy can be processed and the row can be actually marked as consistent with the condition, i.E. Up to date or inserted.
Q26. What Is An Unconnected Lookup?
The unconnected research is entitled to receive input values from the end result of LKP
With unconnected research, it can simplest go back one column value
The unconnected research does now not truly aid user-described default values
Q27. At The Time Of Informatica Powercenter Installation, Can You Please Let Us Know What All Components Are Installed?
The following components are set up whilst putting in Informatica strength center:
PowerCenter customers
Integration offerings
Repository carrier
PowerCenter Domain
Administration console for PowerCenter
Q28. Explain What Are Slowly Changing Dimensions? What Are The Different Types Of Slowly Changing Dimensions That Are Available?
Slow changing dimensions are the ones in which the scale are supposed to be changed in over the years. The sluggish changing dimensions are mentioned as SCD.
They are three distinctive styles of slowly changing dimensions, they may be:
Slowly converting size-Type 1: In this type of SCD it has simplest cutting-edge records
Slowly converting size-Type 2: In this sort of SCD it has both present day data and additionally historical statistics
Slowly changing size-Type 3: In this sort of SCD it has contemporary records plus one preceding file
Q29. Define What Do You Mean By A Workflow?
Workflow can be described as a hard and fast of instructions which might be supposed to speak to the server and letting it understand on a way to put in force the duties.
Q30. Define What Is A Mapplet?
A mapplet is not anything however a recyclable item which uses a mapplet designer.
Mapplet lets in to reuse the trformation good judgment in different mappings.
A mapplet includes a set of trformations.
Q31. What Are The Types Of Loadings That Are Available In Informatica?
In Informatica, they may be two types of loading:
Normal loading
Bulk loading
Normal loading is a technique in which the statistics are loaded separately and it writes a log for the equal. When in comparison to other kinds of loading everyday loading the loading process takes time to the target source.
Bulk loading is a method where a hard and fast of statistics are loaded into the target database at once. When as compared to normal loading procedure, bulk loading procedure takes very much less time to load the facts.
Q32. Explain What Is A Parameter File And Define What Are The Different Values That Are Available In A Parameter File?
A parameter document is not anything however a record which is created in a text editor or a phrase pad.
The following distinctive values can be described in a parameter report, they may be:
Mapping parameters
Mapping variables
Session parameters
Q33. What Is The Use Of Standalone Command Task?
The standalone command mission can be used everywhere inside a workflow technique to execute the shell commands.
Q34. Explain What Is Meant By A Trformation? What Are The Different Types Of Trformations Available In Informatica?
The time period trformation itself depicts the nature of the hobby. It is a repository item in which it generates, modifies and passes the facts.
The following are unique forms of trformations which are available in Informatica:
Aggregator trformation
Expression trformation
Filter trformation
Joiner trformation
Lookup trformation
Normalizer trformation
Rank trformation
Router trformation
