Key Generator Transformation In Bods

17.12.2020
72 Comments
Key Generator Transformation In Bods Average ratng: 5,0/5 2488 reviews
  1. Key Generator Transformation In Bods 2
  2. Key Generator Transformation In Bods 2016
  3. Key Generator Transformation In Bods Online
  4. Key Generator Transformation In Bods 1
  5. Key Generator Transformation In Bods 2017
  • SAP BODS Tutorial

Sep 12, 2013  Key Generation transform helps to generate artificial keys for new rows in a table. Windows 8 enterprise evaluation key generator. 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 dataset.

  • DW & ETL
  1. Mar 01, 2012  To delta load a table which has a surrogate key as primary key you simply combine Table Comparison with Key Generation Transform. Behind the scenes, some not so obvious things go on. The flow itself is simple. The secret is the Table Comparison Transform, that perform the lookup on the target table to get the current status. With this lookup.
  2. Sap Bods Consultant Resume Profile. SAP BODS, Informatica Power center. Created Data Integrator mappings tload the data warehouse, the mappings involved Extensive use of simple and complex transformations like Key Generator, SQL Query transform, Table Comparison, Case, Validation, Merge, lookup etc. In Data flows.
  3. When it is necessary to generate artificial keys in a table, the KeyGeneration transform looks up the maximum existing key value from a table and uses it as the starting value to generate new keys. The transform expects the generated key column to be part of the input schema.
  • SAP BO Data Services
  • SAP BODS Repository
  • SAP BODS Datastores & Formats
  • Data Flow & Work Flow
  • SAP BODS Transforms
  • SAP BODS Administration
  • Multi-user Development
Key
  • SAP BODS Useful Resources
  • Selected Reading

Transforms are used to manipulate the data sets as inputs and creating one or multiple outputs. There are various transforms, which can be used in Data Services. The type of transformations depend on the version and product purchased.

Following types of Transformations are available −

Data Integration

Data Integration transforms are used for data extraction, transform and load to DW system. It ensures data integrity and improves developer productivity.

  • Data_Generator
  • Data_Transfer
  • Effective_Date
  • Hierarchy_flattening
  • Table_Comparision, etc.

Data Quality

Data Quality transforms are used to improve the data quality. You can apply parse, correct, standardized, enrich data set from the source system.

  • Associate
  • Data Cleanse
  • DSF2 Walk Sequencer, etc.

Platform

Platform is used for the movement of dataset. Using this you can generate, map, and merge rows from two or more data sources.

  • Case
  • Merge
  • Query, etc.

Text Data Processing

Text Data Processing allows you to process large volume of text data.

1. Introduction

This document specifies technically, how to Capture Change Data during extraction from SAP R/3 system.

Key Generator Transformation In Bods 2

2. What is Change Data Capturing.

After Initial load is completed, we identify the changed or new record in the source system and update the target system with the changed record. Identifying and loading only changed data is called Change Data Capturing. This type of load is used to maintain the history data in the target system (SCD Type 2).

There are two CDC methods – Source based CDC and Target based CDC.

Source-based CDC evaluates the source table to determine, what record has changed and extracts only changed records to load into target tables.

Target-based CDC extracts all the data from the source, compares the source and target rows using table comparison and then loads only the changed rows into the target system.

3. Extraction using Target-based CDC

For Target Based CDC, we need to have Full and Delta load Data flows. For the Full Refresh, you can dump the data from SAP R/3 or BW into the Staging Table and then, load to the Target table (Oracle Database).

Youtube

1) Full Refresh- Extracting data from SAP R3 table as a dump (Example., we will extract EKPO – Purchase item table data).

a) First, the data is extracted from SAP R3 system (say from table EKPO) and loaded to Oracle Staging table as shown in the below screen shot.

b) From staging table the data is loaded to the target table with a sequence number, that is generated using Key Generation transform.

For more information on, how to extract SAP R/3 Data into Oracle for Full Refresh. Refer the below link How to Extract SAP R/3 Data to Oracle using Business Objects Data Services

2) Delta Refresh – The changed records are identified from the source system and loaded to the target system as a new record. This is SCD type 2 method.

a) After Initial Load (Full Refresh), all the data from EKPO table is extracted and loaded to the staging table.

Windows server 2008 standard key generator. b) Create a Data Flow for delta refresh (EKPO_DELTA_TGT_LOAD) which involves Query, Table Comparison, History Preservation and Key Generator transformation as shown in the below screen shot.

c) Let us consider Column NETPR (Net Price in purchasing document) value changes frequently in SAP R3 EKPO table. The changed data needs to be captured into our target system as a new record,

Key Generator Transformation In Bods 2016

d) The data are extracted from EKPO table and first loaded to the STG table.

e) Query Transform is used to map columns from the Source system. Also this transform can be used as filter from source system to target system using a condition in the Where clause.

f) Table Comparison transform is used to compare the data from the source table with the target table to determine the changes. This transform treats the changed data as insert. Here we compare the NETPR column from source and target to determine the changes.

g) History preserving transform is used to convert the updated rows to Insert rows based on the columns in which values are changed. This transform produces a row with the changed column data to target, instead of overwriting the target row.

Key Generator Transformation In Bods Online

Here in our example, when the NETPR data changes in the source system, this row is inserted as a new row in the target table.

Key Generator Transformation In Bods 1

h) Key Generation transform is used to generate new sequence number for the updated records, which will be used as an insert record in the target table.

Key Generator Transformation In Bods 2017

i) Save and Execute the Job.