What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and how informatica handles them?

Questions by Thananjayan   answers by Thananjayan

Showing Answers 1 - 9 of 9 Answers

You can extend the metadata stored in the repository by associating an repository object  . this is called metadata extension
there are tow types of metadata extensions
user defined
  vendor defined

for example , if u want to add a new port to the source that u can do it by metadata extensions

prabhat007

  • Dec 8th, 2007
 

Metadata Extensions:
Who created,what purpose,version number etc for future enhancements. Information about mapping for other people to better understand.

Metadata information in repository can be reported using informatica metadata tool.

  Was this answer useful?  Yes

ORAINFO

  • Nov 18th, 2008
 

Metadata means data about data. Metadata extension means any additional information about the data. For Example let us consider a source qualifier and then I want to put any extra info about it like date of creation, author etc .this can be put in that metadata extension. We can add a row as we do each time to add a port. The columns of this row are NAME, DATATYPE (string,number,bool), VALUE, RESUABLE, UNOVERRIDE, DESCRIPTION, PRECISION.

Can create them in the SOURCE, TARGET, MAPPINGS, TRANSFORMATION, MAPPLET.


Can be of two types REUSABLE and NON-RESUABLE.


NON-RESUABLE can be converted to REUSABLE but vice-versa is not true.


Only the value column can be changed other columns can't be refined.


Correct me if I am wrong and give any extra info available especially for the
last part - How Informatica deals with it.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions