DSXchange

Hi Gurus,

when are the OCI LOAD and MSSQLSERVER LOAD stage used in the datawarehousing.

At what stage are these stages used in datawarehousing sense.

I know that OCI and MSSQLSERVERLOAD disables the constrainsts and indexes , doesn't check for integrity of data and load the data.

Both deal with separate databases, one deal with oracle and another deal with SQLSERVER.

At which stage of this datawarehousing - are these stages used, why are these stages used.


cheers;
saama

As the name mentions, while loading. These stage utilize the database's bulk loader to blaze data into the table. They are usually used for huge amounts of data.

Interview question?

Saama wrote:I know that OCI and MSSQLSERVERLOAD disables the constrainsts and indexes , doesn't check for integrity of data and load the data.

Not true, at least not as a blanket statement. Or at least not for Oracle. What you say it does is an option in the process.