Multiple choice technology

What is target load plan? What is the main constraint for using this?

  1. Target load plan is the selection of order in which target tables are to be populated. The constraint is that number of target tables to be populated should not be more than number of source qualifiers in the data flow

  2. target load plan is the definition of data load plan. It does not have any constraint

  3. N/A

  4. NA
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Target load plan in Informatica defines the order in which multiple target tables are populated within a single mapping. The constraint exists because you need enough source qualifiers (which represent data sources) to drive the population of each target table in the specified sequence. If you have more targets than source qualifiers, the mapping cannot execute properly.

Keep practicing — related questions