@devanand31 wrote: 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. The target table will contain all rows from both source tables. OUTER UNION CORR concatenates tables without removing any rows.   Combining Queries with Set Operators   ... View more