- Key_generation Function In Bods Pictures
- Key_generation Function In Bods And Dogs
- Key_generation Function In Bods Excel
- Key Generation In Sap Bods
Dec 13, 2018 SAP BODS Quiz: This SAP BODS Expert Quiz contains set of 51 SAP BODS Quiz which will help to clear any any exam which is designed for Expert.
- Follow these steps to use string functions in Data Services using the example of the replacesubstr function, which substitutes part of the string with another substring: Open the DFHelloWorld dataflow in the workspace window and add a new Query transform named WhosaysWhat.
- 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.
Description:
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.
Create a Project
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
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
Click on Finish
After mapping the all new ouput columns ,Validate the current window
Take the Template Table and join to the Query Transformation
Execute the Job
After executing the job check the data in the Target
Thanks for following.
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:-
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.
![Key_generation Function In Bods Key_generation Function In Bods](/uploads/1/2/6/0/126030088/615870889.png)
Key_generation Function In Bods Pictures
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:-
Key_generation Function In Bods And Dogs
CONTENT OF SOURCE DATA:- (containing the modified entry alone)
CONTENT OF QUERY_TRANSFORM:-
CONTENT OF THE KEY_GENERATION TRANSFORM:-
THE CONTENTS OF THE TARGET TABLE PRIOR JOB EXECUTION:-
Key_generation Function In Bods Excel
The JOB_EXECUTION:-
Key Generation In Sap Bods
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.
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……..