Skip to Content
Former Member
Aug 12, 2009 at 07:42 AM

Start routine


HI All,

I am new to writing routines in transformation hence need a help with the below case.

I want to write a start routine ,The Start routine is used in a transformation that will load data from a real time DSO to a Staging DSO.

The need for start routine is, i want to look up into the Real time DSO Active table for a set of key fields for each record to be loaded in Staging DSO from Real time DSO ,sort those records in sequence and finally load only those records that are loaded latest,that is the most recent records for a given set of key fields.

Also, if the latest record is having a delete flag , this record set should not be loaded.