incremental load

[Anonymous]

I Have a Query like this

Select

ID,

Value,

Name

from database

Here i have to implement a incremental load by id. But my incremental load will always fetch only 100 rec from the database since the data volume is too large i need to implement this can any one help me how to set the incremental load with specifice row counts

[#2]

Hello,

Maybe you can try this, after you enter the load statement click on the DEBUG button on the script editor window and then do a Limited Load and type the number of records you want there...I tried this and you can trype number 100 to fetch only 100 records from each table field.

ANDY

[#3]

Hi Narayanan,

If you want to fetch only 100 records then you can use the function "first 100" before your load statement in the table but as you mentioned you want to put incremental load that will fetch only 100 record from your table.Can you tell me on the baisis of what condition you will fetch these 100 records?

Please specifiy how to identify these 100 records.

Regards,

Ravi

[suniljain]

FULL_DATA_TABLE:

Select

ID,

Value,

Name

From Database

concatenate

Load

ID,

Value,

Name

From QVD where not exist(ID);