Basic Informatica Tutorial

Primary Key :- --------------- A primary key is a single field or combination of fields that uniquely identifies a row in the table. Th...

Datamart is the subset (a part) of the Data Warehouse. Datamart focuses on a particular subject or a small business unit where as Data ware...

Dimension stores the textual description of the business. It means it stores the details related to the business transactions like place, d...

Facts are also known as "Measures". These facts are used to measure the business values and forecast business future.  The diff...

Data Warehouse is designed based on Schema's. Whenever we load the data into the warehouse it should be in the form of schema's. In...

Data ware housing concepts are most important in understanding IT work environment. Actually what is data ware housing ? How does it works ...