06 October, 2020
Use the sequence generator transformation in implementing slowly changing dimensions
A sequence generator transformation is created with to default output ports.
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
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 implement an update strategy in two different ways.
The conditions update strategy expression can be developed using an update strategy transformation with the following constants.
DD - Update1
DD - Delete2
IFF(SAV> 2000, DD-INSERT, DD-UPDATE)
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
It inserts the record in the target
It updates the record in the target
It deletes the records from the target
For each update in the source, it inserts a new record in the target
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
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .