Informaticans

A Data warehouse is a copy of transaction data specifically structured for Querying and Analyzing and Reporting. Prefer Informatica to do the ETL process, because Informatica is more powerful in designing and building data warehouses. It can connect to several sources and targets to extract meta data from sources and targets, transform and load the data into target systems.