Feb 20, 2013 Date Generation Transform by using different Date Functions. DateGeneration transform is used for creating time dimension tables. This transform generates a column which holds the date values based on the start & end dates provided as an input to the transform by considering the increment provided to it. Name the column and data type.
- Sap Data Services Pdf
- Sap Data Services 4.2 Manual
- Key Generation Transform In Sap Data Services Schedule
- Key Generation Transform In Bods
Although the Key Generation Transform actually does execute a SQL I put it into the Streamline category because it executes one and only one SQL at the start of the transform and this is a 'select max(key) from table'. In almost all cases this key will be the primary key column which is indexed. So to find a max() the database has to walk to the last element in the key which is an operation done in no-time. Based on this starting value, the transform increases the value by one for each row with OP code Insert or Normal and puts the value into the 'Generated Key Column'.
Throughput | 237'000 rows/sec |
CPU | 100% |
Memory | none |
Disk | none |
DoP | singularization point |
Transform Usage
Transform Settings
To test it, we had to rename the column from DI_ROW_ID to KEY_ID which is the primary key name of another table.
The execution time for above flow without the key generation was 84 secs, so the overhead for the query is about 20 secs. The execution time with Key Generation Transform added as well was 422 seconds which is quite surprising.
Anyway, no memory is consumed, only CPU and the throughput is still at excellent 237'000 rows per second.
Attachment
Job_Key_Generation_Transform.zip (4.98 KB)
Job_Key_Generation_Transform.zip (4.98 KB)
- SAP BODS Tutorial
- DW & ETL
- SAP BO Data Services
- SAP BODS Repository
![Sap Sap](/uploads/1/2/6/0/126075113/984909227.jpg)
- SAP BODS Datastores & Formats
- Data Flow & Work Flow
- SAP BODS Transforms
- SAP BODS Administration
- Multi-user Development
![Key Generation Transform In Sap Data Services Key Generation Transform In Sap Data Services](/uploads/1/2/6/0/126075113/863526064.jpg)
- 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 −
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
Sap Data Services Pdf
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.
Sap Data Services 4.2 Manual
- Case
- Merge
- Query, etc.
Key Generation Transform In Sap Data Services Schedule
Text Data Processing
Key Generation Transform In Bods
Text Data Processing allows you to process large volume of text data.