Informatica Powercenter Tutorials | Informatica Training Videos
Uploaded by: BigOnlineTraining
on Fri, 20 May 2016 20:50:40 IST
Informatica Course Info : http://goo.gl/2TkFJE Major Topics covered in this video: What is Infor... Show more
Informatica Course Info : http://goo.gl/2TkFJE
Major Topics covered in this video:
What is Informatica?
Informatica is an ETL tool from Informatica Corporation.
What is a data?
Data is a measure for any business analysis.
Data is facts and statistics collected together for reference or analysis.
What is a Data Base or Data warehouse, how the data is stored in the Data Base?
What OLAP system?
A Data warehouse is a Data base where a huge number of data can be stored for business analytical purpose and decision making purpose; it contains the Historical Data of an Enterprise.
The Data from different OLTP systems is being loaded in to the Data ware house by the ETL Tool. It is also called as a OLAP system (Online Analytical Process system), where the data is accessed by a BI tool for business analysis.
What is OLTP System?
OLTP system (Online Transactional processing system) like Airline, Railway, Ecommerce etc.,
A Transaction is a set of DML Operations Show less