Using database functions There is no great variety of functions in this area. Data Services encourages you to communicate with database objects and control the flow of data within a - Selection from SAP Data Services 4.x Cookbook Book.

• Sap Data Services Reference Guide
• Key Generation Transform In Sap Data Services Inc

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. When you include the KeyGeneration transform in a data flow, you configure the options in the editor. Would you like to participate in a short survey about the SAP Help Portal? Yes, take me to the survey No. SAP Help Portal SAP Data Services. SAP Data services is one of the finest ETL(Extract, Transform, Load) tools which delivers a single enterprise-class solution for data integration, data quality, data profiling, and text data processing that allows you to integrate, transform, improve, and deliver trusted data to critical business processes. Mar 01, 2012  The secret is the Table Comparison Transform, that perform the lookup on the target table to get the current status. With this lookup, it can read and will output all the columns, even if they are not part of the input schema. An example is the surrogate key of the target table. Keygeneration transform is creating negative key values Negative integers are being assigned via the keygeneration transform The largest keygeneration value is 2,147,483,647 SAP Knowledge Base Article - Preview.

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.

Sap Data Services Reference Guide

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):-

Key Generation Transform In Sap Data Services Inc

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:-

Battlefield 2 deluxe edition cd key generator. 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…….