i have a small problem with "where exists" and a sql load and did not find existing solutions while searching the community. Where existst works fine with qvd containers or resident loads, but seems not to work with external sql sources.
my goal is to limit a load from a qvd container and then limit the load form a sql database by a field from the previous qvd load.
SQL SELECT * FROM DB."customer_orders"
where exists (CU_ID)
All i gt is an error. where exist works with other loads and SQL supports where exists like in this example:
WHERE EXISTS (SELECT *
WHERE suppliers.supplier_id = orders.supplier_id);
I will appreciate any help or suggestions, thank you
Does anyone have a solution for an incremental load situation, where we would like to avoid loading the entire table and then filtering? Specifically, after a load of a qvd that contains order numbers, only select those rows from the database using the order numbers from the qvd. In this situation there is no other way to identify the records in the database.