I'm new to Data Factory, so please forgive my ignorance. I've successfully created a Copy Data activity pipeline and now I'm looking to filter down the data. The activity copies accounts from Salesforce to an Oracle table. Not all of our accounts in Salesforce contain customer numbers. I'm looking to only copy accounts that have a customer number.
In Informatica, it was a matter of a adding a simple expression like: Customer_Number__c <> ''
I'm sure I'll eventually get used to it, but right now I'm finding it confusing and cumbersome to add a filter in Data Factory. Can somebody tell what I need to put into the filter settings (Items & Condition) to properly filter my activity?
Activity: TEST_SF_ACCOUNTS
Source Dataset: Account
Source Field: Customer_Number_c
Sink Dataset: DFACTORY_SF_ACCOUNTS
Sink Field: CUSTOMER_NUMBER
Condition: Customer_Number_c field needs to contain a value
Any help would be appreciated!
