I am passing tFileInputDelimited to tDataPrep component . In scenario where we have more than 70000 records, job goes in infinite loop and does not give any output. How Can I pass range of the records to tDataPrep in iteration rather than passing whole file in single shot. I have tried tSampleRow component which select rows with given range. I got succeeded in doing same In following way,
tFileInputDelimited -> tsampleRow (With Range value as : "1,,1000") -> tDataPrep
again same with different rage
tFileInputDelimited -> tsampleRow (With Range value as : "1001,,2000") -> tDataPrep
I need to find-out algorithm to identify run time with range parameters and iterate this values to tSampleRow
I also add below code in tjava component.
this sample gives out put as for 32000 rows,
Can anyone help me o identify to iterate in tjava component and pass these values to tSampleRow in iteration