Using Expression transformation how to remove duplicate
records from a relational source?
Answer
Expression is a passive transformation. So we can't delete
any row in it. We can achive only by using an active
transformation with/without it (SQ,Filter,Agg..etc).