what is the diff b/w target load plan and cbl?
- 3 Answers
- 26225 Views
- CTS, iGate, I also Faced
- E-Mail Answers
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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to do unit testing in informatica?
What is event and what are the tasks related to it?
How to generate or load values in to the target table based on a column value using informatica etl tool.
expain about the tune parameters?
how many types of dimensions are available in informatica?
How do you load only null records into target? Explain through mapping flow.
without table how to come first record only in oracle?
Define mapplet?
What is a joiner transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the commit type if you have a transaction control transformation in the mapping?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are session parameters ? How do you set them?
