Skip to Content
Author's profile photo Former Member

SAP BO Data Services Transforms – Basics Part4

15. History Preserving Transform:

The History Preserving transform allows to produce a new row in the target rather than updating an existing row. We can indicate in which columns the transform identifies changes to be preserved.

Data Inputs:


    A data set that is the result of a comparison between two images of the same data in which changed data from the newer image are flagged as UPDATE rows and new data from the newer image are flagged as INSERT rows.

Data Output:

                             A data set that is the result of a comparison between two images of the same data in which changed data from the newer image are flagged as UPDATE rows and new data from the newer image are flagged as INSERT rows.



/wp-content/uploads/2014/02/1_390548.jpg


/wp-content/uploads/2014/02/1_390548.jpg


16. Data Transfer:


When there is a need of pushing operations to the database server rather than loading Job server, we can use Data_Transfer as a Transformation step in Data services.

The idea is to push down resource-consuming operations to database server such as Joins, Group By and Sorts using a temporary staging Area.

It writes the data from a source or the output from another transform into a transfer object and subsequently reads data from the transfer object. The transfer type can be a relational database table, persistent cache table, or file.


/wp-content/uploads/2014/02/1_390548.jpg


During run time, a file(unstructured.txt) is created temporarily, and vanish after execution.


Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for the wonderful document..It helped me a lot in learning BODS basics..

      Regards,

      Shaan..