Key Generation Transformation In Sap Bods

 

Use of History Preserving Transform

Introduction:–

Transforms are used to manipulate the data sets as inputs and creating one or multiple outputs. There are various transforms, which can be used in Data Services. The type of transformations depend on the version and product purchased. Data Integration transforms are used for data extraction. KEYGENERATION Transform. KeyGeneration transform helps to generate artificial keys for new rows in a table. The transform looks up the maximum existing key value of the surrogate key column from the table; And uses it as the starting value to generate new keys for new rows in the input dataset.

Feb 29, 2012  Transform Usage. Transform Settings. Obviously, it does not require any memory, but as much CPU as it can get and is rather quick: 100'000'000 records in less than a minute or in other words a throughput of 1.9 million rows per second. Jun 21, 2016 With my diving suit packed, loaded with imaginative visions, and lots of curiosity, started diving deep into the world of BODS.Lots of work is going on. Got attracted towards the “KeyGeneration” transform and was fascinated at its features.Now it was time for me to fuse and adapt myself into its world. THE KEYGENERATION TRANSFORM. Jun 06, 2012  We will demonstrate how to implement Slowly Changing Dimension of Type 2 in SAP BusinessObjects Data Services using History Preserving Transform.

The surrogate key column is created in BODS (in query transform) and this column should be made primary key and use this in Key generation transform. It will create keys serially. It will not create random keys. Sep 18, 2013  Generation Transforms: Key Generation and Date Generation produce millions of records - no memory required. Streamline Transforms: They take data row by row transform each and send it to the output immediately. No performance impact if using those, e.g. Merge, Case, Key Generation, Map Operation, Map CDC Operation, Pivot, History Preserving.

It is used to preserve the history of the source records.Reimage license key generator 1.8.1.4.

If the source row has operation code of Insert/Update then it inserts a new record in the target table.

Scenario:-

Sap bods source control


We are doing a scenario where we want to insert the updated record into target table to preserve the history of the source records.

1) Create project, job, workflow & dataflow as usual.

2) Drag a source table to dataflow. Its contents are as follows.

Transformation

3) Drag a target table to dataflow. Its contents are as follows.

4) Drag query, Table-Comparison, History Preserving blocks as shown in the figure.

5) Open Query & do mappings as you do normally.

6) Open Table_Comparison block & enter all the properties.

7) Similarly provide details for the History_Preserving block.

8) Now after this we have updated 1st 3 rows of source records & 4th row is deleted .

Key Generation Transformation In Sap Bods Pictures

Fields where changes are made are circled with the red marks as seen in the above figure.

Sap Bods Tutorials

9) Validate & Execute the job.

10) 3 new records got added in the target table as shown below.

Key Generation Transformation In Sap Bods Free

You can see that new entry for updated record is made in the target table along with the

‘Y’ flag & new END_DATE as ‘9000.12.31’ & the flag of the original records are changed to ‘N’.

Summery:-

Sap Bods Source Control


Key Generation Transformation In Sap Bods 1

So in this way History Preserving block is useful in preserving the History if the source records.