ACCELERATORS BIBW Xpress

Business Intelligence entails getting the correct data in the most expeditious way.

The LOAD statement is moderately fast and easy to use, but it can only accept specified data formats. You usually use LOAD with data that is prepared with an UNLOAD statement.

You can use the UNLOAD statement in DB–Access to unload selected rows from a table into a text file.

To load tables, use LOAD or dbload. To manipulate a data file that you are loading or to access a database while it is loading, use the dbload utility. The cost of the flexibility is the time you spend creating the dbload command file and slower execution. When possible, use the LOAD statement, which is faster than dbload.

Efficient ETTL process

Today's DBAs and data warehouse architects face ever-increasing storage volumes and processing bottlenecks.

Strict service-level agreement (SLA) commitments and shrinking production windows require world-class database reorg and data warehouse extract,transform, transfer and load (ETTL) solutions that deliver high performance and database availability.