Business Intelligence

Role of Table Index in Data Loading of Info-objects

Role of Table Index in Data Loading of Info-objects

In this article, an example of supplier data in BW is considered. Supplier data from several SAP systems (from table LFA1) or from non-systems are extracted. Standard data cleansing methods are utilized. Some of these could be de-duplication, standardization and enhancement. Enhancement could be an addition of a standard number, eg. DUNS. At the end of this activity there could be tens of thousands of records to be loaded. Since the result of this activity is a flat file, the data is loaded into BW as a flat file. If the info-object does not have a secondary index, the loading time runs into hours.