Which mapping type allows referencing SQL as the target for scripting in Data Management?

• A. In
• B. Outer
• C. Explicit
• D. Multidim

Answer: (A)

In Data Management, mapping types define how data flows from the source into the target and how you apply logic during the load. The option that allows referencing SQL as the target for scripting is the inbound mapping type. This type is designed for paths that bring data into the system and can be tied to SQL-based scripting targets, enabling you to use SQL constructs as part of the data load process. The other mapping types serve different purposes: Outer relates to join behavior in the mapping, Explicit is for mapping explicit values or constants, and Multidim is used for loading data into multi-dimensional targets like cubes. Therefore, the inbound mapping type is the one that best fits referencing SQL as the scripting target.