Key Generation in BODS

 See more in our ebook

 

Key_Generation

To generate artificial keys in Data Integrator,  you can use either Key_Generation Transform or Key_Generation Function. It fetches max. existing key value from the table and uses it as a starting value. Based on this start key, transform/function increments the key value for each row.

Options

There are three options for key generation-

  • Table Name : You should provide table name along with the Datastore and Owner (DATASTORE.OWNER.TABLE)
  • Generated Key Column : The new artificial keys are inserted into this column. Remember that your key column should be in any numeric datatype (REAL, FLOAT, DOUBLE, INTEGER, DECIMAL), if it is any other data type, then Data Integrator will throw an error-
  • Increment value : Specify your interval for system generated key values. Surrogate key will be incremented based on this interval. From 11.7 version onward, you can specify variables also.
Design Steps

In below example, customer information is being  populated. There is a  primary key called Customer_ID in both the source & target tables, but SURROGATE_KEY will be maintained to illustrate the key generation transform-

The source data looks like below-

Key generation transform always expects a SURROGATE_KEY column in SCHEMA IN

After completion of the job execution, below is the customer dimension target data with surrogate key values-

The map operation does the insert and the key generation transform creates a new key for each inserted record.

 

See more in our ebook

Comments

Post a Comment

Popular posts from this blog

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more

How to update exchange rates via process chain in BW

Image
 The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain. Include the step ‘Execute ABAP Program’ in the process chain. Give the program name as ‘RSIMPCURR’. Create a variant for the program.
Read more

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more