Informatica Data Engineering Foundation cheat sheet
Informatica Data Engineering Foundation · Keep the key ideas within reach.
Enterprise Catalog
Catalog objects: assets (tables, files, reports, APIs), domains, glossaries, business terms, policies, and data-quality rule links.
Business glossary vs technical metadata: glossary defines business meaning and owners; technical metadata captures schema, data types, and physical location.
Search relies on asset metadata, tags, classifications, and glossary linkage. Discoverability improves when assets are assigned to a domain and owner.
Lineage in the catalog is captured via parsed SQL, ETL job metadata, and manual assertions; column-level lineage is more precise but harder to obtain.
Certification/endorsement flags mark assets as trusted; unendorsed assets should not be used for regulated reporting without review.
Social curation: ratings, reviews, and Q&A on assets surface quality issues; stewards resolve and update asset descriptions.
Asset onboarding workflow: register source, scan/profiling, classify sensitive columns, link glossary terms, assign owner, then publish.
Catalog-to-governance link: classification tags drive access policy enforcement; a missing tag is itself a governance finding.