Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27514 Views
- CTS, iGate, I also Faced
- E-Mail Answers
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 can we use mapping variables in informatica? Where do we use them?
How to differentiate between the active and passive transformations?
Explain the code page compatibility?
Partition, what happens if the specified key range is shorter and longer
Difference between Data and Index Caches?
what is the Default Source Option For Update Strategy Transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Whats there in global repository
How do you load only null records into target? Explain through mapping flow.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the size of your data warehousing?
Can we create two repositories on same database instance in oracle?
What is lookup change?
What are the types of data warehouses?
What are different types of transformations available in informatica?
