2. What is Informatica PowerCenter?

Informatica PowerCenter is basically an ETL tool that provides the foundation of all major data integration projects. It is generally used in building Data Warehouses for enterprises and businesses. ...

3. List some popular Informatica products?

The popular Informatica products are as follows: PowerCenter. Informatica Data Engineering. Product 360. Informatica MDM. Informatica Intelligent Cloud Services. Informatica Data Quality. Informatica Data as a Service. Axon Data Governance. ...

4. What is Informatica ETL tool?

ETL stands for Extract Transform Load. It is basically a data integration tool that is used to first extract data from sources, then transform it to make it compatible, and then load it into the destined system. ...

iPaaS stands for "Integration Platform as a Service" is a platform that helps in building the data integration with the cloud and between the cloud and enterprises, such that it removes the requirement of any physical hardware as the enterprises can ...

6. What is Lookup transformation in Informatica?

Lookup transformation is a passive transformation that is used as a join operation in between the source table and lookup table. It is generally used to look up the source in order to get the relevant data. ...

7. What are mapplets?

Mapplets are reusable objects that contain a set of transformations that you can use in multiple mappings. An active mapplet can return a number of rows that are different from the number of source rows. Mapplet is basically used to transform the dat ...

8. Explain Aggregator transformation in Informatica?

Aggregator transformation performs aggregate calculations like sum, average, etc. using a temporary placeholder to store the records of operation performed over the rows. To perform this, aggregator cache memory is used. ...

9. What is surrogate key?

A surrogate key is a key that s manufactured artificially and only for the purposes of data analysis. Surrogate keys can also include the current system date/time stamp or a random alphanumeric string. ...

10. What is Union transformation?

Union transformation is just like the UNION ALL set operation, which is a multi-input group transformation used to merge the data from multiple pipelines into a single pipeline. ...

18th
Jun

Informatica MCQ

Admin
18th Jun, 2022
399 Followers

Informatica MCQ Questions

1. What Is Informatica.
2. Which is the reusable component in Informatica?
3. ETL Stands for -
4. Which one is not correct about filter transformation?
5. Which of the following server governs the implementation of various processes among the factors of server’s database repository.
6. Which of the following transformation is used to combine data from different sources?
7. What is the full form of OLAP?
8. Which of the following transformation is used to handle cobol sources?
9. Which of the following window in desginer is used to access the repositories?
10. Which of the following option is need to be checked for creating shortcuts for folders?
11. Which of the following session property enabled when update strategy is used in a mapping?
12. Which of the following tool is used for users, user groups and priviledges?
13. The repository server create and update the repository tables through -
14. Which of the following transformation is used to convert the rows in to columns?
15. Which of the following Transformation is used to load the rejected records?
16. Which of the following types of sources are available in informatica?
17. Which of the following component of informatica is used to see the performance of the workflow while running?
18. Can INFORMATICA objects be written in XML format?
19. What is the different components of PowerCenter?
20. What are the two types of Repositories in INFORMATICA?

Take Informatica Quiz To test your Knowledge

Below are few Informatica MCQ test that checks your basic knowledge of Informatica. This Informatica Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best Informatica interview questions.