Synthetic Key's in Informatica

Synthetic Key's in Informatica

Use the sequence generator transformation in implementing slowly changing dimensions

A sequence generator transformation is created with to default output ports.

1. 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

1. start value(zero)
2. current value (one)
3. 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.

If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.

The Informatica power center allows you to implement an update strategy in two different ways.

1. Using update strategy transformation at the mapping level.
2. Using target table properties as session-level.

The conditions update strategy expression can be developed using an update strategy transformation with the 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 the following targetable properties at session-level to implement an update strategy

1. INSERT

It inserts the record in the target

2. Update as update

It updates the record in the target

3. DELETE:-

It deletes the records from the target

4. Update as Insert:

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

5. update else insert:

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

For in-depth understanding of Informatica, click on

• Rank Transformation in Informatica
• Aggregator Transformation in Informatica
• Expression Transformation in Informatica
• Lookup Transformation in Informatica
• ETL Project Architecture
• Interview Questions