what is the diff b/w target load plan and cbl?
Answer Posted / sai krishna karri
Target load plan is that you can set at the Informatica
level whereas the Constraint based load ordering is what
happens at the database side.
Whenever you have multiple pipelines in your mapping, you
can set the order of execution of those pipelines, which to
run first and which next. Whenever u select the target load
plan, it displays the list of source qualifiers lying in
the different pipelines. You just need to arrange the
source qualifier as per your requirement and save your
mapping.
Constraint based load ordering is an option in the session
properties where the informatica understands that the
parent table has to be loaded before the child table. You
need not determine which table to load first and which
next, all you need to do is just check the 'Constraint
based load ordering' option in the session properties. This
applies when you have multiple targets in the same pipeline
simultaneously(like multiple targets from the same
transformation or multiple targets from the same output
group of a router etc..)
Is This Answer Correct ? | 40 Yes | 0 No |
Post New Answer View All Answers
How does a sorter cache works?
What is transformation?
What is a standalone command task?
What is xml source qualifier transformation in informatica?
How an expression transformation differs from aggregator transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Which is the t/r that builts only single cache memory?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Why sorter is an active transformation?
What are Dimensional table?
What is the difference between stop and abort in informatica
How to load a Dimension ? and how to load a fact table?
How we can create indexes after completing the loan process?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How big was your fact table