Is there any way to implement the row_number (Oracle function) in Data Integrator within a query transform?
Detail:
I want to implement the following query in a query transform. How can I do it. My source and target tables are template tables.
Insert into Target_Table
Select * from (
select
Column1,
Column 2,
Column 3,
Column 4,
Column 5,
row_number() over (partition by Column1, Column 2, Column 3
order by Column1, Column 2, Column 3 ) RN
from Source_table)
where RN = 1
Any pointers are appreciated.