I am trying to compare two tables by using Table comparison transform.
Now my requirement is, i want to compare two tables and update my one of table with only a flag say ''Y'' if i found a match in the target table.
But when i use table comparison transform it directly Updates my target table or it inserts a new record if that record is not available.
Can i get some way out ,that after comparison it returns me just a flag value so that i can update my target table with that flag and if that record does not exists
in my target table then i will insert in target table.
I tried putting validation rule after table comparison transform but it didn't worked.
So any other way to do the above scenario.