可以考虑在数据工厂中使用缓存,以加快 Lookup 活动的启动时间。可通过在 Lookup 活动中配置 CacheOption 属性并设置为 Enabled 来启用缓存。具体代码示例如下:
{ "name": "Lookup1", "type": "Lookup", "dependsOn": [], "policy": { "timeout": "7.00:00:00", "retry": 0, "retryIntervalInSeconds": 30, "secureOutput": false }, "typeProperties": { "source": { "type": "SqlSource", "sqlReaderQuery": "SELECT * FROM dbo.table WHERE Column1 = @Column1", "parameterValues": { "Column1": "@pipeline().parameters.Column1" } }, "dataset": { "referenceName": "SqlServerTableDataset", "type": "DatasetReference" }, "firstRowOnly": true, "cache": { "enabled": true, "expiry": "00:05:00" } } }
此代码启用了包含 5 分钟过期时间的缓存。可根据实际需求调整缓存时间。