Hi,
I want to apply analytical function row number for taking row numbers and filter my source records to rownum=1 using which i can filter my data which is moving to target based on rownumbers ,wrote in sql for my data set it worked fine coming to ODI
The way i am thinking to implement in ODI12c is using expression from componet pallete and add rownumber as this function then use a filter and apply =1 logic
and pass my data set to target
but in this case i need to take whole colmuns copy from target to expression first and then map to filter and target
IS there any other easy method to implement this anaytical rank function in odi12c ,could anyone kindly help me