Let’s get deeper into what’s new in this version. Recently SAP has released SAP BusinessObjects Data Services 4.1 version (Ramp-Up) which features many enhancements and new features. The following Target objects can be used and different access method can be applied.SAP BusinessObjects Data Services delivers a single enterprise-class solution for data integration, data quality, data profiling, and text data processing that allows you to integrate, transform, improve, and deliver trusted data to critical business processes. TableĪ file formatted with columns and rows as used in relational databasesĪ template table that has been created and saved in another data flow(used in development)Ī file with an application-specific format(not readable by SQL or XML parser)
The following type of source object can be used and different access methods are used for the source objects. Target objects − Target Objects defines the target to which you load or write the data. Source objects − Source objects define the source from which data is extracted or you read the data. Source and Target ObjectsĪ data flow can extract or load a data directly using the following objects −
Step 2 − Change the properties such as Execute only once, Degree of parallelism and cache types. In-memory − Choose this value if your data flow processes a small amount of data that can fit in the available memory. 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 kommentar(er)
