Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which…

Question

Options

• Athe Load Technique tab in the Table Loader transformation properties window
• Bthe Indexes tab in the table properties window
• Cthe Columns tab in the table properties window
• Dthe Columns tab in the Details panel of the open job, with the table selected in the job flow

• A
  95% (60)
• B
  3% (2)
• C
  2% (1)

Explanation

Option A is correct because the Load Technique tab in the Table Loader transformation controls how data is physically written to a table (e.g., append, replace, or update strategy) - it is a loading configuration screen, not a metadata display panel, so it has no facility for showing column index definitions.

Options B and C are both valid: the Indexes tab in the table properties window is the most direct place to inspect index definitions, while the Columns tab in the same window can indicate index membership alongside other column attributes. Option D is also valid because selecting a table node in the job flow and viewing the Columns tab in the Details panel surfaces the same column-level metadata, including index information.

Memory tip: Think of it as structure vs. strategy. Index metadata belongs to the table's structure (properties windows, details panel). The Load Technique tab is about strategy - it answers "how do I write the data?" not "what columns are indexed?" If a tab configures behavior, it won't display structural metadata.

No community discussion yet for this question.