Informatica - What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and ho

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 587 of 644

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

Total Answers and Comments: 3

Last Update: November 19, 2008 Asked by: Thananjayan

Sponsored Links

Best Rated Answer

—

Submitted by: chandrarekha

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

Above answer was rated as good by the following members:
DK_Reddy

November 28, 2007 13:09:44

chandrarekha

Member Since: May 2007 Contribution: 14

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

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 08, 2007 06:43:23

prabhat007

Member Since: November 2007 Contribution: 2

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

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.

Is this answer useful? Yes | No

November 18, 2008 08:01:26

ORAINFO

Member Since: November 2008 Contribution: 6

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

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank