Hi Team, I would like to understand how does Talend process the data from Input till output in case we have cursor option active in advanced setting for postgressql input versus inactive.
Let say I have 1 Lk record so, when we haven't enable the cursor option then it will first fetch all the data and store in talend or DB? or it will select and stream on fly? or there is any limit it do?
However, I know in case cursor option is selected with 10K row it will wait until this 10K record will not loaded to output table or is't something else???
I have not checked this issue before. But the best way to verify will be from DB Monitoring tools as they will give real time data flow metrics.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
