GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 13 of 60    Print  
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: 4 Last Update: December 06, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 10, 2005 03:26:32   #1  
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
December 14, 2006 15:14:49   #2  
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   #3  
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
December 06, 2007 02:03:06   #4  
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


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape