ASP.NET 2.0 Question:

How do you remove duplicates without using remove duplicate stage?

ASP.NET 2.0 Interview Question
ASP.NET 2.0 Interview Question

Answer:

In the target make the column as the key column and run the job.


delete table tablename where rowid not in Select * from tablename group by column name


Previous QuestionNext Question
What tag do you use to add a hyperlink column to the DataGrid?can u explain one critical mapping?
performance issue which one is better? whether connected lookup tranformation or unconnected one?