1.

Discuss Which Is Better Among Incremental Load, Normal Load And Bulk Load.

Answer»

It depends on the requirement. Otherwise Incremental load which can be BETTER as it takes one that data which is not available PREVIOUSLY on the TARGET.

According to performance bulk is better than normal. But both having some conditions in source data.

Conditions are like:

  1. Does not contain any constraint in data.
  2. Dont use the double DATATYPE if necessary to use then use it as last row of the table.
  3. It does not support the CHECK CONSTRAINT.

It depends on the requirement. Otherwise Incremental load which can be better as it takes one that data which is not available previously on the target.

According to performance bulk is better than normal. But both having some conditions in source data.

Conditions are like:


Discussion

No Comment Found

Related InterviewSolutions