ETL (Extract, transform, load) Question:

Download Job Interview Questions and Answers PDF

Explain What is the metadata extension?

Extract, transform, load (ETL) Interview Question
Extract, transform, load (ETL) Interview Question

Answer:

Informatica allows end users and partners to extend the metadata stored in the repository by associating information with individual objects in the repository. For example, when you create a mapping, you can store your contact information with the mapping. You associate information with repository metadata using metadata extensions.

Informatica Client applications can contain the following types of metadata extensions:

Vendor-defined. Third-party application vendors create vendor-defined metadata extensions. You can view and change the values of vendor-defined metadata extensions, but you cannot create, delete, or redefine them.
User-defined. You create user-defined metadata extensions using PowerCenter/PowerMart. You can create, edit, delete, and view user-defined metadata extensions. You can also change the values of user-defined extensions.

Download Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
How to call shell scripts from informatica?Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?