How to limit the number of record to be reloaded for script testing

[#1]

Hello,

I need to load a fact table with more than 33 million records, but I only want to reload the first 10,000 recodes for testing the script. Any way can do this?

Thanks,

[rbecher · Accepted solution]

FIRST 10000 LOAD....

or

FIRST (10000) SELECT...

- Ralf

[hopkinsc]

You could use a WHERE statement in the load script.

" Where (FieldName >0 and FieldName <10000);

[#4]

In the script window, click on Debug. Here you can do a number of things, one of which is a Limited Load. Check the Limited Load box and set the number of records you want to bring in. This will bring in that number of records for each data source.

[#5]

Thanks Ralf,

It works.