Informatica free tutorial

Informatica Free Tutorial

Introduction to Informatica Reason for build Data warehouse:

Data warehouse:-(W.H.Inmon) A data ware house is a time variant Non-volatile Subject oriented integrated database

Characteristic and Features of DatawareHouse Time-variant:A Datawarehouse is a time-variant database which supports business needs of end users in comparing and analyzing the business with different time periods.

This is also knows as time series analysis.

Non-volatile:A data ware house is a non-volatile once the data entered into the data warehouse it doesn’t reflect to the change which takes place at operational database. Hence the data is “static� in the data warehouse.

Subject Oriented:A data warehouse is a subject oriented database which supports the business need of department specific users. Ex:- sales, accounts, hr. students, lones etc....

A subject is derived from multiple OLTP applications which organizes the data to meet specific business functionality.

Integrated:A data warehouse is an integrated database which collects the data from multiple OLTP database

Informatica Concepts A data warehousing is a process of building a data warehouse. A process includes. Business requirement analysis, database design, ETL development and testing, Report development and testing.

A business analysis and onsite technical co-ordinates gathers the business requirement and technical requirements.

Data Acquisition It is a process of extracting the relevant business information. Transforming data into a required business format and loading into the target system. A data acquision is defined with following type of process data extraction data transformation data loading There are two type of ETL used to build data Acquisition

•Code base ETL •GUI base ETL

And Also Issues Interview Questions How to’s For More Informatica Free Tutorials Please Visit: http://bit.ly/1xalX2L