Multiple choice technology

Which one of these are the best pratices to follow for the design of the mappings?

  1. use active transformations as early as possible in the mapping

  2. use the #where# condition in the source qualifier before any active transformations which does the same work

  3. use a source qualifier instead of joiner when joining two homogenous sources

  4. try to follow the particular order while configuring ports in transformations - I,I/O,V,O
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

All four options are Informatica mapping design best practices: place active transformations early to reduce data volume, use source qualifier filters before transformations for better performance, prefer source qualifiers over joiners for homogeneous sources (faster), and follow port order I/I/O/V/O (Input, Input/Output, Variable, Output) for readability and maintainability.

Keep practicing — related questions