ETL - What is Informatica Metadata and where is it stored?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 13 of 65

What is Informatica Metadata and where is it stored?

Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations during the ETL process.

The Informatica Metadata is stored in Informatica.

Total Answers and Comments: 5

Last Update: November 14, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Ravichandra

Metadata isÂ data decription of data. sourcedef, targetdef, mappings, mapplets, transformations, database connection names, password, tasks, worklet, workflow are nothing but a metadata i.e., stored in Repository.

Above answer was rated as good by the following members:
CRavikumar, t.manjula

May 10, 2005 03:26:32

kiran

RE: What is Informatica Metadata and where is it stored?

Informatica Metadata contains all the information about the source tables target tables the transformations so that it will be useful and easy to perform transformations during the ETL process.

The Informatica Metadata is stored in Informatica repository

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 14, 2006 15:14:49

Anil

RE: What is Informatica Metadata and where is it store...

Informatica Metadate is nothing but the source definition target definition and the transformations that have been built. They are stored in the respository server and is managed by Repository manager of the informatica client tool.

Is this answer useful? Yes | No

June 18, 2007 05:02:50

Ravichandra

RE: What is Informatica Metadata and where is it store...

Metadata is data decription of data. sourcedef targetdef mappings mapplets transformations database connection names password tasks worklet workflow are nothing but a metadata i.e. stored in Repository.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 06, 2007 02:03:06

Thananjayan

Member Since: November 2007 Contribution: 15

RE: What is Informatica Metadata and where is it stored?

All informations about the mappings workflows such as Source target transformations are converted into metadata format and it is stored in the Repository database.The repository database is a open database which can be accessible by the Repositoy server and Informatica server.

Cheers
Thana

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 14, 2008 07:17:00

VIJAYdw9

Member Since: November 2008 Contribution: 1

RE: What is Informatica Metadata and where is it stored?

Metadata is simply documentation for a digital geospatial dataset. It is a text document that describes the who what when where why and how questions about the data so that a potential data user can decide whether or not the data is appropriate for his/her use."

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top

User Name		Remember Me?
Password

Question Bank