Max records in Transform Cleanse?

Toad Data Point & Toad Intelligence Central
1

Is there a maximum number of records the Transform and Cleanse step can process in Toad Workbook? We have a step where we are trying to add a Calculated field to 1.4M records. It tries to process it for about 10 minutes and then locks up.

From what I can tell, Transform Cleanse runs really slow as it is, but would like to know if there's a limit. We are using ver 6.4.

Thanks
Eric

2

Hi Eric,

There are no limitations regarding data size in the T&C step but the performances will be impacted based on it. You can try to decrease the size of the sample data in the T&C step and then try to add the Calculated field. Try with 1000 rows or something similar.