Informatica Powercenter Tutorials | Informatica Training Videos

This site requires Adobe Flash Player on your browser.
Please install Adobe Flash Player from here.

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

Click here for Embed Code
  Embed: Hide

Comments