Grafx IT Solution Informatica Informatica : Informatica is powerful ETL tool from Information Corporation, a leading provider of enterprise data integration software and ETL softwares. In informatica, all the Metadata information about source systems,target systems and transformations are stored in the Informatica repository. Informatica’s Power Center Client and Repository Server access this repository to store and retrieve metadata.. Data Warehouse and ETL Concepts What is Data ware House Characteristics of the Data ware House OLTP Vs OLAP Dimensions Tables Vs Fact Table Advantages of Data ware House Data Marts Data ware House Vs Data Mart Data Extraction Data Transformation Data Loading Overview of ETL Architecture Data Staging Area Database Designs(Star Schema, Snowflake Schema etc) Database Concepts What is Database DDL,DML,DCL AND TCL Set Operators Sub Queries Group By and Having Clause Joins Power Centre Components Informatica Architectu...
Comments
Post a Comment