none
Oracle Sink - Evaluate Check_Contraints

    Question

  • Since the Oracle sink defaults to a Direct Path Load, it bypasses the tables primary key constraints. I would like to add the 

    EVALUATE CHECK_CONSTRAINTS clause to the insert statement.

    Does anyone know how to do this?

    thanks


    Thursday, October 25, 2018 5:03 PM

All replies

  • Hello, 

    Have you tried adding the clause right under the insert like:

    INSERT INTO exampletable EVALUATE CHECK_CONSTRAINTS

    ...

    ..

    .



    Friday, October 26, 2018 2:34 AM
    Moderator
  • Obviously that is how it would be done if I were writing a SQL statement, but the question is how do you do that in ADF.

    I have a pipeline, using a copy data activity, where I have a SQL Source and a Oracle sink.

    Where on the screen can I specify the clause.

    Monday, October 29, 2018 6:51 PM