Informatica metadata tables is itself a vast topic to discuss

Follow the links to get an idea:

http://www.dwbiconcepts.com/etl/14-etl-informatica/41-informatica-metadata-tables-overview-and-tutorial.html

http://www.dwbiconcepts.com/etl/14-etl-informatica/42-how-to-get-informatica-repository-information-from-metadata.html

http://www.dwbiconcepts.com/etl/14-etl-informatica/43-how-to-get-folders-and-mapping-names-from-informatica-metadata-query.html

Later we will come up with a comprehensive list as suggested.