i have source model and target model, in my source model DIM_PRODUCT data store which contains 2000 records,i want to load 700 records to target datastore for that
in my source datastore in model level i applied a new condition on product_id,i applied CKM ON MODEL LEVEL,everything is fine but it loads 2000 records into target,how can i achieve
please guide me.
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.