Join this group to access featured content and participate in discussions related to DMX.

144 Members
Join Us!


  • Hi Hameed,

    Here I need few details on you data load process into Oracle table , Is it Truncate Insert ? Or Insert load(Maintain History) ?

    If it is Truncate insert we have option in expression builder called "TargetRecordsNumber() " which generate number automatically based on records from source.

    path --> Expression Builder --> Functions -->Number -->TargetRecordNumber().

    If it is Insert process we have multiple options to handle this. Please let me know your options so that I can give more information on this.

This reply was deleted.

To access Syncsort Knowledge Base, visit:

My Support