14 Replies Latest reply on Oct 4, 2018 8:04 AM by dan.smith@informatica.com

    Tables without Primary Keys

    praveengoud Seasoned Veteran

      We are starting to notice that some of our tables do not have Primary keys and because of this CDC is not being propagated to the Target table.

       

      I tried defining composite Primary keys on these tables at Informatica level (Target Designer), but looks like it is not working. I am not sure if i am doing something wrong.

       

      Is there any other way/approach to handle this scenario for tables without any Primary Keys?

       

      Thank you.