4 Replies Latest reply: Sep 27, 2013 1:14 AM by jagan mohan rao appala RSS

    Update Values in Resident table

      Somebody please help me on this:

      I have a table in Load script like this.

       

      FACT:

      Load MyId,

             X,

             Y;

      SQL xxxxxxxx;

       

      Left Join (FACT)

      Load MyId,

              //Append Columns

              Z;

      WHERE Exists (MyId, MyId);

      SQL xxxxxxx;

       

      Since it is a left join, I need to update the Z = Y if it is NULL. How can I do this???