Skip to Content
0
Former Member
Jan 05, 2011 at 06:37 PM

Implementing row_number() oracle function in Data Integrator 11.5

646 Views

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.