![]() ![]() You can select one of the following values for the Cache type option on your data flow Properties window − You can cache data to improve performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons. ![]() Database links allow local users to access data on a remote database, which can be on the local or a remote computer of the same or different database type.ĭegree Of Parallelism (DOP) is a property of a data flow that defines how many times each transform within a data flow replicates to process a parallel subset of data. It is recommended that you do not mark a dataflow as Execute only once if a parent work flow is a recovery unit.ĭatabase links are communication paths between one database server and another. ![]() When you specify that a dataflow should only execute once, a batch job will never re-execute that data flow after the data flow completes successfully, except if the data flow is contained in a work flow that is a recovery unit that re-executes and has not completed successfully elsewhere outside the recovery unit. You can set various properties for a dataflow. Step 1 − To change the properties of data flow, right click on Data flow → Properties You can change the properties of a dataflow like Execute once, cache type, database link, parallelism, etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |