Key Generation Transformation In Sap Bods

Key Generation Transformation In Sap Bods Average ratng: 5,6/10 6491 reviews
  • SAP BODS Tutorial

Date Generation Transformation in SAP BODS. SAP BODS Effective Date Transformation in SAP BODS. Hierarchy Flattening Transformation in SAP BODS. Key Generation Transformation Summary: Key Generation Transformation is used to generate artificial keys for new rows in a table. The transform looks up the maximum existing key value of the. Mar 01, 2012  Effective Date Transform is somehow like an previous row operation: It takes the date of the next row as end date of the current row. One thing to watchout in this transform is, it uses the primary key information to identify the groups. In all the other transforms, there was an extra column list, here it is the primary key. May 09, 2013  Use of History Preserving Transform. Introduction: – It is used to preserve the history of the source records. If the source row has operation code of. Is there any function in BODS to generate a row sequence, but you cann't use KeyTansfertion transform. SAP Data Services. Use the keygeneration built-in.

  • DW & ETL
  • SAP BO Data Services
  • SAP BODS Repository
  • SAP BODS Datastores & Formats

Sap Bods Tutorial Pdf

  • Data Flow & Work Flow

Key Generation Transformation In Sap Bods Calculator

  • SAP BODS Transforms
  • SAP BODS Administration
  • Multi-user Development
  • SAP BODS Useful Resources
  • Selected Reading

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.

Following types of Transformations are available −

Key Generation Transformation In Sap Bods Pictures

Data Integration

Data Integration transforms are used for data extraction, transform and load to DW system. It ensures data integrity and improves developer productivity.

  • Data_Generator
  • Data_Transfer
  • Effective_Date
  • Hierarchy_flattening
  • Table_Comparision, etc.

Data Quality

Data Quality transforms are used to improve the data quality. You can apply parse, correct, standardized, enrich data set from the source system.

  • Associate
  • Data Cleanse
  • DSF2 Walk Sequencer, etc.

Platform

Platform is used for the movement of dataset. Using this you can generate, map, and merge rows from two or more data sources.

  • Case
  • Merge
  • Query, etc.

Text Data Processing

Text Data Processing allows you to process large volume of text data.

Use of History Preserving Transform

Introduction:

It is used to preserve the history of the source records.

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

Scenario:-

Origin download stuck on resuming.

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. Osstatus key generation failed 25293. Its contents are as follows.

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.

Key Generation Transformation In Sap Bods 1

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 .

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

9) Validate & Execute the job.

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

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:-


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