In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ?how can u do this ?

prasanth

• May 17th, 2006

 

You use a sql over ride using 'rownum'

Sudhakar Reddy

• May 22nd, 2006

 

Prashanth, Can u please expain in detail?

nan.kumar

 Profile Answers by nan.kumar 

• May 22nd, 2006

 

Hi,select * from (select col1, col2,rownum rn from table_name ) where rn > ( select (max(rownum) -n) from table_name );Nanda

viswanath

• May 26th, 2006

 

in db2 we write statement as fetch first 500 rows only.

in informatica we can do by using sequence generator and filter out the row when exceds 500

Krishna Ramineni

• Jun 6th, 2006

 

You can overide the sql Query in Wofkflow Manager. LIke

select * from tab_name where rownum<=1000

minus

select * from tab_name where rownum<=500;

This will work fine. Try it and get back to me if u have any issues about the same.