What is difference between cbl (constaint based commit) and target based commit?When we use cbl?

  • Interview Candidate
  • 3
  • 3067

Showing Answers 1 - 3 of 3 Answers

chandumedum

  • Jan 25th, 2008
 

CBL means constaraint based loading.the data was loaded into the the target table based on the Constraints.i.e if we want to load the EMP&DEPT data,first it loads the data of DEPT then EMP because DEPT is PARENT table EMP is CHILD table.

easily to undestand,it loads PARENT table first then CHILD table.
  

  Was this answer useful?  Yes

roshan239

  • Jul 19th, 2010
 

You have asked a wrong question coz there is no concept constraint based commit.. It is constraint based ordering and target load plan which is for user to differentiate where data is to be loaded first. Mostly used in snow-flake schema.


Another concept is source based commit, target based commit and user defined commit.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions