Suppose you have table "sample" & three columns in that tablesample:Cola Colb Colc1 10 1002 20 2003 30 300Assume: cola is primary keyHow will you fetch the record with maximum cola value using data stage tool into the target system

Interview Candidate
Dec 29th, 2006
2
2010

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

Guest

Jan 12th, 2007

Hi
As per the question it is very clear that the source data is in Table
you can use oci stage to read the source file
in the oci Stage write user defined sql query as " Select Max(cola) from the table" which will fetch the maximum value available in the table then load the data to Target Table
Hope u got me
Thanks
Rk