regarding oci load and sql loader

[Saama]

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

[DSguru2B]

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.

[ray.wurlod]

Interview question?

[chulett]

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.