How to run a sample of data from a datajob in dm studio

[beamer108]

I have a long running datajob that I am testing and each time I make a change to the code I need to run the job to see if my changes worked.  Is there a way to run the job but only get a sample of the data to help speed up the time its taking me to develop and test this job?

[audrey]

Hi,

There might be 2 things you can use:

- Previewing the node which can be done by Right-click > Preview (also use F6)

- Changing the MAX_OUTPUT_ROWS for your Input node: this will reduce the records read from the input database

Hope this helps.

Audrey

[beamer108]

Thanks Audrey - I gave it a try and used 50 as my max output - unfortunately its still runs the full time as before. 

[audrey]

Can you give a little more details about your job?

What nodes do you use, what data do you read, how long does it take to run?

Thanks.

Audrey