Role of Metadata in ETL: When you deal with a data warehouse, various phases like Business Process Modeling, Data Modeling,…
Technical Metadata: Technical metadata describes information about technology such as the ownership of the database, physical characteristics of a database…
Metadata: Metadata is data about data. Metadata comes into picture when we need to know about how data is stored…
Metadata Tools: Metadata is data about data and Metadata tools are used for gathering, storing, updating, and for retrieving the…
Power Exchange: Informatica Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by…
Informatica: Informatica is a powerful ETL tool from Informatica Corporation, a leading provider of enterprise data integration software and ETL…
XML Source Qualifier Transformation: XML Source Qualifier is a Passive and Connected transformation. XML Source Qualifier is used only with…
Sequence Generator Transformation: Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key…
Lookup Transformation: Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to…
Aggregator Transformation: Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages…