Data Transformation and the New Integration in SAP BW 7.4
The additional rise for BW 7.4 release is high in the part of data load features. Initially, there are some fresh data load options in BW 7.4. Now we can create generic delta extraction for the UD (Universal Data) and DB (Database Connect) alternatively, including the flat files.
We can also use the latest DataSource adapter named Web Service Pull to load the data from external web services. You can also create the generic Web Services delta loads and load the new data directly into the staging area of BW 7.4.
Some of the new features that improve data load:
SAP BW 7.4 Data Activation features:
In BW 7.0, all the way through activation BW had to look up in the NIRV table to see that the object already survive or not. This could be a very slow process. We had some essential tools to assist us in tuning this. We could safeguard the number choice to evaluate the data load with records in-memory to pace up data activation process.
However, in BW 7.4 the data activation is altered from particular lookups to package fetch of the active table, ensuing in earlier activation and less locks on the lookup tables. The latest process may result in between 15-30% faster data activation.
You now can also use the new BW 7.4 initial load runtime options Insert only and the unique data records only to avoid all the look-ups during activation.
Data transformation in SAP BW 7.4:
A data transformation in BW 7.4 suggests a Read from DataStore option for a quicker data look-up. In addition, the usage of navigational attributes as sources in Masterdata transformations lessen the over head for lookups. United, this may guide to an extra 10-20% improvement.
New integration of hierarchies:
While the web services do not hold hierarchies up till now, there is currently an integration of hierarchies into the standard process flow such as DTPs and transformation, as well as being able to load hierarchies from flat file by a latest DataSource.
An additional immense transform is that when you make use of delta loads, the first time BW 7.3 mechanically describes it an init load after that it automatically toggle to delta as the InfoPackage mode.
Overall, huge innovative features that can appreciably progress the data load. The blend of new activation options in BW 7.3 and the delta tools may be the major reasons why we have to reflect on the improvement rather than later!