Post reply

what are the ways to do incremental loading

  • June 25, 2010 at 3:48 am

    #222548

    hi everyone..

    I want to do incremental loading,we have millions of records,so lookup ,conditional split may take long time,is there any better way to do incremental loading,performance should be good.please give better solutions,it will be helpful to me.waiting for your replies..

    regards..

    anil

    Regards..
    guru12

  • June 25, 2010 at 9:12 am

    #1185071

    [font="Comic Sans MS"]

    This will help you. See here![/url]

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

  • July 6, 2010 at 1:48 am

    #1188962

    Hi Sabya..

    Thank you for your suggestion,and i have another query.

    How to do incremental loading for each table,source and destiantion i can configure but what about the lookup table.

    Is there any better way not using diffetent data flow task for each table.please suggest it will be helpful

    Regards..

    Anil...

    Regards..
    guru12

  • July 6, 2010 at 1:59 am

    #1188969

    Anil,

    Unfortunately, you will require a seperate DFT for each of your transformation.

    Raunak J

  • July 6, 2010 at 3:28 am

    #1188989

    hi raunak..

    Thanks for your help

    Regards..

    Anil...

    Regards..
    guru12

  • July 6, 2010 at 4:10 am

    #1188999

    Anil,

    Just to decrease the overload of multi-package execution you ay choose to Set the RetainSameConnection to True for your OLEDB/ADO.NET connection to increase performance, considerably.

    Hope this helps!!!:-):-):-)

    Raunak J

  • July 6, 2010 at 6:14 am

    #1189048

    Hi Anil,

    The MD5 checksum will look after that..because if any alteration is made the checksum value will be changed.

    Raunak J

Viewing 7 posts - 1 through 6 (of 6 total)

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