Hello,
I have to implement a groupby condition and remove the duplicate records from output table. I could do that in sql and my query looks like this:
select col1,col2,col3, COUNT(col3) from TARGET_TABLE group by col1, col2, col3 having count(col3) >=2
I get 99 records when i run this query in sql. I need that 99 records to go in as error table output in DI and remaining records to TARGET_TABLE.
Where can i insert the sql and get two outputs (final output) and (error table).
Appreciate your ideas.
Arun