DW - Extraction with RI issue RRS feed

  • Question

  • We have question to taking approach for Extracting data from source to target. 
    Our approach is:
    1) Drop the RI Constraints 
    2) Truncate the Tables
    3) ReCreate the  RI Constraints
    4) Extract data from source to target

    Now confusion is during this process before or during recreating RI constraints if we loose DB connection or something outage happen then we loose to ability to Recreate

    RI Constraints.What your thoughts and advice?
    Tuesday, July 2, 2019 11:24 AM

All replies

  • Hi friend,

    When you have outage/loosing the DB connection, we will end up with partial RI constraints created on the DB.

    When you restart a job then make sure to check if RI constrain already exist do not create, otherwise create it 


    Srinivasa Rao G, MCSE(Business Intelligence) Blog: TechTalksPro

    Please mark as answer if my post is helped to solve your problem
    and vote as helpful if it helped so that forum users can benefit

    Thursday, July 25, 2019 3:36 PM