1 / 14

UPDATE STRATEGY TRANSFORMATION

TRANSFORMATIONS. Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target. Transformations are of two types: 1) Active 2) Passive. Update Strategy transformation. Update

rigg
Download Presentation

UPDATE STRATEGY TRANSFORMATION

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. UPDATE STRATEGY TRANSFORMATION Basics and Advanced Concepts

    2. TRANSFORMATIONS Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target. Transformations are of two types: 1) Active 2) Passive

    3. Update Strategy transformation Update transformation is an Active and Connected transformation. An Update strategy is used if you want to Create a strategy for your processing such as Insert, Update, Delete or Reject An Update strategy is generally used when we have determined whether we want to keep the historical data or just the most recent changes

    4. SETTING THE UPDATE STRATEGY WITHIN THE MAPPING Rows are flagged for insert,update,delete or reject within the mapping using a update strategy transformation CONFIGURE A SESSION We can select the insert,delete,update option for the Treat Row as option in the Session Properties

    5. To create a Update Strategy transformation in a Mapping : In the Mapping Designer, choose Transformation-Create. Select the Update Strategy transformation. Enter a name for the Rank. The naming convention for Update transformations is UPD_TransformationName. Click Create, and then click Done. The Designer creates Update transformation. Link columns from an input transformation to the Update transformation.

    6. Click on the button in the Update Strategy Expression Field Enter an update Strategy expression to flag rows as INSERT,DELETE,UPDATES OR REJECTS. Validate the Expression Click ok

    7. Flagging Rows within a Mapping FLAGGING ROWS WITHIN MAPPING

    8. FORWARDING REJECTING ROWS By default the update Stratetgy forwards the rejected rows to the next Transformation. The Power Center Server flags the rows for reject and writes them in the SESSION REJECT FILE IF we do not select the Forward Reject Rows Option, the Power Center Server drops the rejects rows and writes them to the session log File

    9. Update Strategy Used in the Mapping Figure 11-1. Sample Mapping with a Update StrategyTransformation

More Related