is there a pushback in knime?

Hello,
When i joined two table in knime, firstly selects are working and after that join is working so there is no pushback which means there is not a good performance, is there any way to just create one sql and send it to our dwh? or knime works like piece of sql codes to complete join?
thanks.

Hi there @ege1010,

Welcome to KNIME Community Forum!

What node are you talking about? The Database Manipulation nodes push(back) SQL. For example for joining you should use Database Joiner node which will not read your tables into KNIME.

Additionally if you are just starting using KNIME for your DWH I suggest to check out new Database Integration nodes. There are supposed to be production ready in next summer release. Currently they are in KNIME Labs and need to be installed.

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.