In SAS Data Integration Studio, an index can be specified/defined in which location?

Question

Options

• Athe Indexes tab in the properties of a Table Loader transformation
• Bthe Indexes tab in the properties of a table metadata object
• Cthe Indexes tab in the properties for any transformation
• Dthe Indexes tab in the properties of a job metadata object

• A
  8% (2)
• B
  88% (21)
• C
  4% (1)

Explanation

In SAS Data Integration Studio, indexes are a property of the table metadata object itself - they describe how the physical table is structured and accessed, not how any particular transformation processes it. This makes option B correct: the Indexes tab lives in the table's own properties, where you define which columns are indexed and what type of index to use.

Why the distractors are wrong:

• A is wrong because the Table Loader transformation handles loading data into a table, not defining the table's structural metadata like indexes.
• C is wrong because most transformations (joins, sorts, filters, etc.) have no concept of indexes - only table metadata objects do.
• D is wrong because a job metadata object represents the ETL job/workflow itself, not any specific table's storage characteristics.

Memory tip: Think of an index as belonging to the table, not the process. Just as you'd define an index on a database table in a DDL statement - not in a stored procedure - in SAS DI Studio you define it on the table metadata object, not on any transformation.

No community discussion yet for this question.