Post reply

problem loading data using modified date

  • July 20, 2010 at 2:47 am

    #139800

    Hi every one..

    can any one briefly explain how to do incremental loading,i have a modified date column in my source table .so how can i do incremental loading .Have any documents on this, please post it.

    Regards..

    Anil....

    Regards..
    guru12

  • July 20, 2010 at 2:58 am

    #1195365

    For each record in your source, check for existence (match on PK) in destination. In pseudo code:

    If Exists 'Record already exists

    If Source_Modified_Date <> Destination_Modified_Date 'Does record need to be updated?

    Update_Destination_From_Source

    End If

    Else 'Record does not exist in destination

    Create_Destination_from_Source

    End If 'Move to next record in Source

  • July 20, 2010 at 3:30 am

    #1195374

    stewartc-708166 (7/20/2010)

    select col1, col2,.... from sourceTable

    where modifiedDate > (select max(modifiedDate) maxMod from destinationTable)

    That's a better way of identifying your source data - every record will result in an INSERT or an UPDATE.

  • July 20, 2010 at 7:28 am

    #1195502

    Thanks for your valuable suggestions,i will try both and i will get back to you if any queries..

    Regards..

    Anil..

    Regards..
    guru12

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply