Hi ,   Im seeing the out of the Append Table task as a distinct records of the observations.   My Append Table task has the below logic, select * from tablea outer union corr select * from tableb;   if tablea is having any duplicate records, then the output of the Append Table is having only one records. Is this the default behavior of Append Table task? Kindly advice. Thanks in advance.   Regards, Dev    ... View more