Did you enable flow control in your interface ? If yes it should load only the rows that meet your condition in the target table and load the remaining rows in an error table.
Isn't preferable to add a filter (on the model or in the interface) instead of using a condition. This will only filter data (regardless on wether or not flow control is enabled) but won't insert it into error table.
Thanks for quick reply,i have no keys in my target datastore, so i disable FLOW_CONTROL false,ikm sql control append
If you can't define a unique key, then you can't use flow control.
If your goal is to filter data, use a filter instead.
thanks it works fine