IDQ Interview Question & Answers

Below mentioned are the most frequently asked Informatica IDQ Interview Questions. Check below the informatica data quality interview questions.

1. What are the different types of loading present in Informatica?

There are pair of styles of filling, normal loading, and also bulk loading. It gets relatively a more ample opportunity to bunch records to the aim at in normal loading.

2. Define Informatica repository?

Informatica Repository: The Informatica repository is the crucial part of the Informatica suite. You create multiple metadata tables in the repository database where the Informatica application and tools gain access. The Informatica client and server will access the repository to save and retrieve metadata.

3. What is Surrogate Key?

The surrogate key is nothing but a sort of substitution for the natural primary key. A surrogate key is just a unique identifier or number of each row used for the table’s primary key.

4. What does Transformation mean in IDQ? Mention the various types of transformations available in Informatica?

A transformation is a repository objective that produces, changes, or even passes records. An Aggregator transformation conducts estimates on teams of records.

5. What is Aggregate Cache in Aggregator transformation?

The aggregator accumulates information in the aggregate store till it accomplishes aggregated computations. The Informatica hosting server generates indexes and data stored in memory to refine the Transformation when operating a treatment that uses an aggregator transformation. The remaining values are stored in cache files whenever the Informatica server requires additional space.

6. Which tasks are performed by the Source qualifier?

Source qualifier helps in assimilating the data evolving from the same database source. And it helps in the filtration of source data while the Informatica server reads the data. While sorting the records, the Source qualifier suggests involving an outer join rather than the inner join, the present default. It also creates a custom query in the Informatica server while reading source data and provides a unique “select” statement.

7. How can you use Union Transformation?

The union transformation is a multiple-input team transformation that could combine records coming from a variety of resources (or even pipes). This Transformation functions like UNION ALL statement in SQL, which integrates the result collection of multiple SELECT declarations.

8. What is the target load order?

Indicate the target load order based upon resource qualifiers in a mapping. Suppose you possess several resource qualifiers connected to the number of targets. In that case, you can easily mark the order in which the Informatica hosting server fills up the information right into the targets.

9. What is a lookup transformation?

It reviews lookup transformation slots (input slots) to the resource pillar located on the lookup circumstances. Later on, come back worth’s may be passed to various other makeovers. It contrasts lookup transformation slots (input slots) to the resource pillar worth’s located on the lookup circumstances.

10. Which Transformation can you use while using COBOL sources as source definitions?

Normalizer transformation is utilized to stabilize the records since COBOL resources usually include Denormalized records.

11. How can you differentiate between a connected lookup and an unconnected lookup?

Unconnected lookup does not take inputs straight coming from some other transformation. However, it may be used in any transformation (like the phrase) and could be implemented as a functionality using LKP articulation. An inapplicable lookup can easily be contacted numerous opportunities in an applying.

12. Does Joiner Transformation allow combining two flat files?

Yes, we can utilize joiner transformation to sign up with records coming from pair of standard documents resources.

13. Name the various data that passes through the Informatica server and stored procedure?

Three types of data are present, which pass through the Informatica server and stored procedure. They are such as,

• Input/Output parameters
• Return Values
• Status code.

14. What is the source qualifier transformation?

You require to attach it to a source qualifier transformation when you incorporate a relational or even a level documents resource interpretation to an applying. When it functions as a treatment, the source qualifier transformation expresses the reports that the Informatica Server reviews.

15. What is a Status code?

The stored process will provide a status code that alerts whether the stored procedure finished adequately or not. Status code delivers error handling for the Informatica hosting server throughout the session process. It helps identify the status of the session if the session has stopped or working.

16. What are the different types of loading present in Informatica?

There are pair of styles of filling, normal loading, and also bulk loading. It gets relatively a more ample opportunity to bunch records to the aim at in normal loading.

17. Define Informatica repository?

Informatica Repository: The Informatica repository is the crucial part of the Informatica suite. You create multiple metadata tables in the repository database where the Informatica application and tools gain access. The Informatica client and server will access the repository to save and retrieve metadata.

18. What is Surrogate Key?

The surrogate key is nothing but a sort of substitution for the natural primary key. A surrogate key is just a unique identifier or number of each row used for the table’s primary key.

19. What does Transformation mean in IDQ? Mention the various types of transformations available in Informatica?

A transformation is a repository objective that produces, changes, or even passes records. An Aggregator transformation conducts estimates on teams of records.

20. What is Aggregate Cache in Aggregator transformation?

The aggregator accumulates information in the aggregate store till it accomplishes aggregated computations. The Informatica hosting server generates indexes and data stored in memory to refine the Transformation when operating a treatment that uses an aggregator transformation. The remaining values are stored in cache files whenever the Informatica server requires additional space.

21. Which tasks are performed by the Source qualifier?

Source qualifier helps in assimilating the data evolving from the same database source. And it helps in the filtration of source data while the Informatica server reads the data. While sorting the records, the Source qualifier suggests involving an outer join rather than the inner join, the present default. It also creates a custom query in the Informatica server while reading source data and provides a unique “select” statement.

22. How can you use Union Transformation?

The union transformation is a multiple-input team transformation that could combine records coming from a variety of resources (or even pipes). This Transformation functions like UNION ALL statement in SQL, which integrates the result collection of multiple SELECT declarations.

23. What is the target load order?

Indicate the target load order based upon resource qualifiers in a mapping. Suppose you possess several resource qualifiers connected to the number of targets. In that case, you can easily mark the order in which the Informatica hosting server fills up the information right into the targets.

24. What is a lookup transformation?

It reviews lookup transformation slots (input slots) to the resource pillar located on the lookup circumstances. Later on, come back worths may be passed to various other makeovers. It contrasts lookup transformation slots (input slots) to the resource pillar worths located on the lookup circumstances.

25. Which Transformation can you use while using COBOL sources as source definitions?

Normalizer transformationis utilized to stabilize the records since COBOL resources usually include Denormalized records.