X hits on this document

421 views

0 shares

1 downloads

0 comments

36 / 131

Load

Load

Load

Load

Load

LKM File to MSSQL (BULK)

Loads data from a File to a Microsoft SQL Server staging area database using the BULK INSERT SQL command.

Because this method uses the native BULK INSERT command, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data. However, the loaded file must be accessible from the Microsoft SQL Server machine.

Consider using this LKM if your source is a large flat file and your staging area is a Microsoft SQL Server database.

LKM MSSQL to MSSQL (BCP)

Loads data from a Microsoft SQL Server source database to a Microsoft SQL Server staging area database using the native BCP out/BCP in commands.

This module uses the native BCP (Bulk Copy Program) command to extract data in a temporary file. Data is then loaded in the target staging Microsoft SQL Server table using the native BCP command again. This method if often more efficient than the standard “LKM SQL to SQL” when dealing with large volumes of data.

Consider using this LKM if your source tables are located on a Microsoft SQL Server instance and your staging area is on a different Microsoft SQL Server instance.

LKM MSSQL to MSSQL (LINKED SERVERS)

Loads data from a Microsoft SQL Server source database to a Microsoft SQL Server staging area database using the native linked servers feature.

This module uses the native linked servers feature to access the source data from the target Microsoft SQL server staging area. It doesn't create a staging file in the middle as with the BCP method. It relies on the MSDTC mechanism. It can be appropriate for large volumes of data.

Consider using this LKM if your source tables are located on a Microsoft SQL Server instance and your staging area is on a different Microsoft SQL Server instance.

LKM MSSQL to Oracle (BCP/SQLLDR)

Loads data from a Microsoft SQL Server source database to an Oracle staging area using the MS SQL Server BCP tool and the native SQL*LOADER command line utility.

This LKM uses the MS SQL Server BCP tool to extract a user-defined data set to a flat file. The data from this flat file is then loaded with Oracle SQL*Loader (SQLLDR) into a temporary table (C$) within the stating area of target Oracle data server.

Other Oracle IKMs can then be used to finalize the loading of data into target data store.

LKM SQL to MSSQL

Loads data from any Generic SQL source database to a Microsoft SQL Server staging area. This LKM is similar to the standard “LKM SQL to SQL” described in section “Generic SQL” except that you can specify some additional specific Microsoft SQL Server parameters.

Knowledge Modules Reference Guide

36/131

Document info
Document views421
Page views424
Page last viewedSat Dec 10 12:10:33 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments