Key Generation Transformation In Sap Bods
- 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.