Informatica Free Tutorial

Introduction to Informatica Reason for build Data warehouse

Data warehouse:-

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.

Synthetic Key's

Use the sequence generator transformation in implementing slowly changing dimensions A sequence generator transformation is created with to default output ports.

• Textual Curial

This transformation doesn't allow you to create new ports or edit the existing output ports. set the following properties to generate the sequence no's

• start value(zero)

• current value (one)

• Increment by (one)

Update strategy transformation

This is the type an active transformation which flag the source records form insert, updata, delet and reject data driven operations. An update strategy transformation functions as dml commands in SQL An update strategy transformation operates on target database account. The target table should required a primary key to update the records. An update strategy transformation is used in implementation slowly changing dimensions. The informatica power center allows you to implementing an a update strategy in a two different ways.

• Using update strategy transformation at mapping level.

• Using target table properties as session level.

The conditions update strategy expression can be developed using an update strategy transformation with following constants. DD-Insert 0 DD - Update1 DD - Delete2 DD-Reject 3 conditional Expression IFF(SAV> 2000, DD-INSERT, DD-UPDATE) OR IFF (SAL> 2000,0,1) The default update strategy expression is "DD-INSERT" Use he following targetable properties at session level to implement an update strategy

• INSERT

It insert the record in the target

• Update as update

It updates the record in the target

• DELETE:-

It delete the records from the target

• Update as Insert:

For each update in the source it inserts a new record in the target

• update else insert:

It updates the record if it exit in the target else inserts the record in the target.

For More Follow Below Link:

http://bit.ly/1xalX2L

#informaticafreetutorial #informaticatutorial