Key_generation Function In Bods
Description:
Go to Functions and select Date Functions then weekinyear function and click on Next. Select the DateGeneration Transform generated column then click on Finish. After mapping the weekinyear and create another New Output Column to Quarter of the Year. Give the name and data type for another output column then click on OK. May 26, 2015 Thanks for A2A Trupti Mayee Tripathy. I do not have much knowledge about SAP BODS but please find the below beginners guide I found: SAP BODS - Beginners guide.
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 surrogate key column from the table and uses it as the starting value to generate new keys for new rows in the input data set. Feb 29, 2012 DI has the key generation transform to provide values for surrogate keys. It works similar to the identity column logic, take the highest key value and increment it by one. However, the Identity column checks the highest value for each and every row, Key Generation transform only once, at the beginning of the dataflow.
Date_Generation 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.
Here is the step by step guide to achieve the transformation.Origin key generator free download no survey.
Create a Project
Add a Key Generation object from the transform/platform area. Add a Template Table from the Menu in the Right, Enter its name & the select the data store where it needs to be created. Connect Source table to the Query object, query object to the Key generation object & Key generation object to the template table. Jun 21, 2016 Exploring:- Key Generation transform in SAP BODS designer. 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.
Create a Batch Job
Take Work Flow and Data Flow
Take Date Generation Transformation
Double Click on Date_Generation Transform and Provide the details as below
Take the Query Transformation and join to the Date Generation Transformation
Go to Query Transform and Create New Output Column
Provide the Name for the Output Column to return the week in year
Key_generation Function In Bods 2016
Go to Functions and select Date Functions then week_in_year function and click on Next
Select the Date_Generation Transform generated column then click on Finish
After mapping the week_in_year and create another New Output Column to Quarter of the Year
Give the name and data type for another output column then click on OK
Go to Functions and select Date Functions and the select quarter and click on Next
Select the Date_Generation transform generated column and click on OK
Click on Finish
Again create another output column return last date
Name the column and data type for the newly created output column
Go to Date functions and select last_date function then click on Next
Key_generation Function In Bods And Dogs
Click on Finish
After mapping the all new ouput columns ,Validate the current window
Take the Template Table and join to the Query Transformation
Key Generation In Bods
Execute the Job
After executing the job check the data in the Target
Thanks for following.