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