Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Use SF_Refresh with criteria and/or only a subset of fields for the object.

I'm attempting to pull fields from the Account object. I need to pull records that only meet certain criteria and only 10 of the hundred of fields we have on the account object. This needs to be refreshed on a nightly basis. Is there any derivation of sf_refresh/sf_replicated that can be used to do this? Looks to me like I can't use any criteria in sf_refresh/sf-replicate or only specify specific fields. My criteria yields about 280,000 rows and doing a select field1,field2,field3, etc from salesforce...account is taking a considerable amount of time. 15 minutes and counting.
1 person has
this question
+1
Reply