Metadata Reports: Metadata stored in a repository can be produced in the form of reports for easy understanding and these reports are very useful in explaining about the various objects or data structures and the relationship between these objects. The following products like Schema Logic Enterprise Suite, Rochade, Metatrieve, Datamapper, Metacenter, Metadata Integration Frame work…
Role of Metadata in ETL: When you deal with a data warehouse, various phases like Business Process Modeling, Data Modeling, ETL, Reporting etc., are inter-related with each other and they do contain their own metadata. For example in ETL, it will be very difficult for one to extract, transform and load source data into a…
Technical Metadata: Technical metadata describes information about technology such as the ownership of the database, physical characteristics of a database (in oracle, table space, extents, segments, blocks, partitions etc), performance tuning (processors, indexing), table name, column name, data type, relationship between the tables, constraints, abbreviations, derivation rules, glossary, data dictionary, etc., and is used by…
Metadata: Metadata is data about data. Metadata comes into picture when we need to know about how data is stored and where it is stored. Metadata tools are helpful in capturing business metadata and the following section explains business metadata. Business Metadata: In IT, Business Metadata is adding additional text or statement around a particular…
Metadata Tools: Metadata is data about data and Metadata tools are used for gathering, storing, updating, and for retrieving the business and technical metadata of an organization. Data – The actual data that is stored in the database. Business Metadata – The information of the data related with business and this data is used by…
Power Exchange: Informatica Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs. Power Exchange supports batch, real time and changed data capture options in main frame (DB2, VSAM, IMS etc.), mid range (AS400 DB2 etc.,), and for relational databases (oracle,…
Informatica: Informatica is a powerful ETL tool from Informatica Corporation, a leading provider of enterprise data integration software and ETL software. The important Informatica Components are: Power Exchange Power Center Power Center Connect Power Exchange Power Channel Metadata Exchange Power Analyzer Super Glue In Informatica, all the Metadata information about source systems, target systems and…
XML Source Qualifier Transformation: XML Source Qualifier is a Passive and Connected transformation. XML Source Qualifier is used only with an XML source definition. It represents the data elements that the Informatica Server reads when it executes a session with XML sources. Advanced External Procedure Transformation: Advanced External Procedure transformation is an Active and Connected…
Sequence Generator Transformation: Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers or to replace missing keys. It has two output ports to connect transformations. By default it has two fields CURRVAL and NEXTVAL(You cannot add ports to…
Lookup Transformation: Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables. For example, if we want to retrieve all the sales of a product…
