Multiple choice technology databases

Which three property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose three.)

  1. Define the connection properties to an ODBC data source.

  2. Define columns for the output link.

  3. Specify properties for the input link.

  4. Define columns for the input link data.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

When using the ODBC connector stage as a target, you must define: (1) connection properties to reach the ODBC data source, (2) input link properties to control how data flows into the stage, and (3) column definitions for the input data to map incoming fields. Output link column definition (Option B) is not required for a target stage since data flows in through the input link, not out.

Keep practicing — related questions