In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table ?

sravan kumar

• Dec 3rd, 2006

 

Use sql override

Query goes like this, If I Take Table name as AS EMP, then....

SELECT * FROM  EMP

WHERE ROWNUM<=(SELECT COUNT(*) FROM EMP) MINUS

SELECT * FROM EMP WHERE ROWNUM<=(SELECT COUNT(*)-n FROM EMP);

N=NUMBER IN EMP TABLE WE HAVE 14 TABLES IF U GIVE N AS 3 THEN IT WILL GIVE U LAST 3 ROWS. OK

SRAVAN GOPISETTY.

sravan_gopisetty@yahoo.com

krishnasri424

 Profile Answers by krishnasri424 

• Dec 7th, 2006

 

hi,connect a sequence generator next to source qualifier into the expression.Use the filter trans to filter rows like where nextval>500.

sravan kumar

• Dec 7th, 2006

 

We can go with sequence generator but if u want to increase the session performance go for SQL Override

bala

• Dec 12th, 2006

 

Hi,

If the source is flatfile we can't use sql override. 

Better go for sequence generator,conn.. the s.g o/p to expression trns..

inside the expr.. trns.. we can write condition like 

sequence no.>=500 and sequence no.<=1000.

sequence no. are what you are getting from s.g.

You should set sequence trns.. in reset mode, then only you can get same no. for every exec..

Infoseek

 Profile Answers by Infoseek 

• Jan 7th, 2007

 

hi  the above condition holds good in case of static loading,

say, I have 10000 recs in my source to load, but while loading it fails say at 6887th record,

how can i reload just the remaining record 3313 records alone :-)

thanks in advance. infoseeker

R.Ravikumar

• Jan 17th, 2007

 

hello mr.info seek ... in tht secniro we have to go for store procedure.. it will call the last inserted value from the target table and then from tht row it will insert the next value...
bye

nagaramakrishna_wh

• Feb 1st, 2007

 

Hi if it is flat file then all the properties in the SQ will be disable then how can i write in SQL override

sreedhark26

 Profile Answers by sreedhark26 

• Mar 12th, 2007

 

u can load 500 records, then we can use Transaction control transformation, give the condition for 500 records out of 1000.

dl_mstr

 Profile Answers by dl_mstr 

• Feb 10th, 2008

 

SELECT *
FROM (select * from source_table ORDER BY rownum DESC) Source
WHERE rownum <= 501