IDQ Certification interview Question & Answers

1. What does Maplet do?

Maplet is a collection of transformations that you construct in the maplet professional, and also, you may usemultiple mappings.

2. What are sessions and batches?

A session is nothing but a collection of orders that illustrates the webserver to relocate information to the target.

And a Batch is nothing but a collection of jobs that might consist of several duties (treatments, celebration delay, e-mail, order, etc.).

3. Define slowly changing dimensions?

Slowly changing dimensions are nothing but the dimensions which change over concerning time.

They are of three types.

1. Type1- only current records are present
2. Type2- current records along with historical records are also present.
3. Type3- current records along with previous records are present.
   
   
4. What does Active and Passive transformations?

Active Transformation: An operational transformation may transform many lines that travel through it, coming from resource to target, i.e., it does away with lines that perform certainly not comply with the disorder in Transformation.

Passive Transformation: A passive transformation does not transform the variety of lines that travel through it, i.e., it passes all lines through the Transformation.

5. Define Aggregator Transformation.

Aggregator transformation is a Connected as well as energetic Transformation. This Transformation serves to estimate amounts and standards (primarily to carry out forecasts on several lines or even teams).

6. What is the Sorter transformation?

Sorter transformation is a Connected as well as an Active transformation. It makes it possible to arrange information either in coming down or even rising purchase depending on a pointed out area.

7. What is Rank transformation?

Rank transformation is a Connected and also energetic transformation. It helps to decide on the lower or even best rank of recorded data.

8. What is the Router transformation?

Router transformation is a Connected and also energetic transformation. The only variation is filteredTransformation falls the records that perform certainly not fulfill the ailment. In contrast, the router possesses an alternative to catching the forms that carry out, which certainly does not satisfy the condition.

9. What is Normalizer transformation?

Normalizer Transformation is a Connected as well as energetic Transformation. It is utilized primarily along with COBOL resources, where information is usuallypresent in a denormalized style. We can use Normalizer transformation to produce several rows coming from a singular row of recorded data.

10. What are lookup transformation?

Lookup Transformations can easily access information coming from relational desks that are certainly not sourced in applying.

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.