Cursor size in TOracleInput

Highlighted
One Star

Cursor size in TOracleInput

Hi All ,
What is standard size for cursor size in to
toracleInput ? what happens if we keep it as maximum and by keeping it as minimum?
Seventeen Stars

Re: Cursor size in TOracleInput

This attribute name is a bit misleading. Actually it means the fetch size for the result set. The fetch size describes how much datasets will be read at once. The default value differs a bit and is mostly 64 or 100.
In case of reading a lot of datasets it is recommended to use a fetch size about 10000.
There is a individual maximum which value increase the performance. Please keep in mind all datasets inside the fetch size window will be kept in memory.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog