Next article Key Generation Transformation in SAP BODS. RELATED ARTICLES MORE FROM AUTHOR. Difference Between Main Window and Variable Window in SAP. Display PO And Goods Receipt Details Against Purchase Requisition – SAP Reports.
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 Key for generac generator 22 27 kw generator. 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.
Microsoft office product key generator 2016.
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:-
![]()
THE CONTENTS OF THE TARGET TABLE PRIOR JOB EXECUTION:-
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.
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…….
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:-
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.
Sap Bods Tutorial Point
2) Drag a source table to dataflow. Its contents are as follows.
Key Generation Transformation In Sap Bods Pictures
https://celestialcentre923.weebly.com/blog/key-generator-for-windows-7-ultimate-32-bit-free. 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.
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’.
Sap Bods Designer
Summery:-
Key Generation Transformation In Sap Bods 1Key Generation Transform In Sap Bods
So in this way History Preserving block is useful in preserving the History if the source records.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |