what is the diff b/w target load plan and cbl?
Answer Posted / vijay
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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
update strategy transformation in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to delete duplicate row using informatica?
what are 3 tech challenges/ common issues you face?
What is the meaning of up gradation of repository?
What are active transformations.
Differentiate between a database and data warehouse?
What are the differences between joiner transformation and source qualifier transformation?
What is the function of aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
difference between informatica 8.1.1 and 8.6
Please let me know how to make Data masking in informatica..
What is aggregator transformation in informatica?
What do you mean by channel change?
generate date / time dimension in informatica