Vast is an Ocean,So is vast the World of Knowledge. 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 “Key_Generation” transform and was fascinated at its features.Now it was time for me to fuse and adapt myself into its world.
THE KEY_GENERATION TRANSFORM:-
Def:- Row generation Produces a data set with a single column.The column values start with the number that you set in the Row number starts at option. The value then increments by one to a specified number of rows.
![What is bod meeting What is bod meeting](/uploads/1/2/5/8/125869745/687151024.jpg)
This transform is categorized under the “Data Integrator Transforms”. This generates new keys for source data, starting from a value based on existing keys in the table we specify.
If needed to generate Artificial keys in a table, the Key_Generation transform looks up the maximum existing key value from a table and uses it as the starting value to generate new keys.
The transform expects the generated key column to be part of the input schema.
STEPS TO USE KEY GENERATION TRANSFORM:-
Scenario:- Here the target data source for which the keys is needed to be added, have certain newly added rows without a Customer_ID. This could be easily understood in the following snap:-
Our aim here is to automatically generate the keys(Customer_ID) in this case , for the newly inserted records which have no Customer_Id. Accordingly we have taken the following as our input (the modified data without Customer_ID)
INPUT DATA (to be staged in the db):-
TARGET TABLE(which contains the data initially contained in the source table before the entry of new records in the database):-
THE GENERATED DATA FLOW:-
CONTENT OF SOURCE DATA:- (containing the modified entry alone)
CONTENT OF QUERY_TRANSFORM:-
CONTENT OF THE KEY_GENERATION TRANSFORM:-
What Is Bod Testing
THE CONTENTS OF THE TARGET TABLE PRIOR JOB EXECUTION:-
Bod Key Products
The JOB_EXECUTION:-
THE OUTPUT AFTER THE JOB EXECUTION:-
We can now see from the output how Keys have been generated automatically to those records which did not have the Customer_ID initially.
Key Generation Software
I explored this little process of the Key_Generation transform, and it seems a savior at times when huge amount of data have the missing entries(wrt to the keys or any sequential column fields).
Now its time to go back to the surface of waters……..
- SAP BODS Tutorial
- DW & ETL
- SAP BO Data Services
- SAP BODS Repository
- SAP BODS Datastores & Formats
- Data Flow & Work Flow
- SAP BODS Transforms
- SAP BODS Administration
- Multi-user Development
- SAP BODS Useful Resources
- Selected Reading
![Software Software](/uploads/1/2/5/8/125869745/183714524.png)
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
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.