OLTP Data Warehouse

Online transaction processing (OLTP) is a class of systems that supports or facilitates high transaction-oriented applications. SQL server integration systems (SSIS) primary system features are immediate client feedback and high individual transaction volume.

OLTP is mainly used in industries that rely heavily on the efficient processing of a large number of client transactions, e.g., banks, airlines and retailers. Database systems that support OLTP are usually decentralized to avoid single points of failure and to spread the volume between multiple servers.

OLTP systems must provide atomicity, which is the ability to fully process or completely undo an order. Partial processing is never an option. When airline passenger seats are booked, atomicity combines the two system actions of reserving and paying for the seat. Both actions must happen together or not at all.

Heavy OLTP system reliance brings added challenges. For example, if server or communication channels fail, an entire business chain can grind to an immediate halt.

Examples of OLTP transactions include:

  • Online banking
  • Purchasing a book online
  • Booking an airline ticket
  • Sending a text message
  • Order entry
  • Telemarketers entering telephone survey results
  • Call center staff viewing and updating customer's details
  • SSIS Data Conversion


    Drag and drop the data flow task from the toolbox to control flow and rename it as SSIS Data Conversion Transformation.

    Drag and drop EXCEL Source, Data Conversion Transformation from toolbox to data flow region.

    Double click on Excel source in the data flow region will open the connection manager settings and provides option to select the table holding the source data.

    he above screenshot you can observe that we are selecting the DimProducts.xls file present in our local hard drive

    From the above screenshot you can observe that, we are selecting the Product Destination table present in the DimProducts.xls.

    Click on columns tab to verify the columns. In this tab we can uncheck the unwanted columns also.