You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)

• A. Input columns must all be of the same data type.
• B. All columns are combined into a vector of the same length as the number of columns.
• C. Columns must be in consecutive order.
• D. Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
• E. Input columns must form a numeric sequence.

You are responsible for managing job changes for you project team. You must update the source code repository through Eclipse Team source code integration whenever a developer notifies you of an asset change.
What two tasks allow you to update the source code repository with the changed asset? (Select two)

• A. Right-click the asset and click the Build command
• B. Right-click the asset and click the Team command to commit the artifact to the source control system.
• C. Right-click the asset and click the Send to Source Control Work Space.
• D. Right-click the asset and click the Deploy command

What role must a user have to delete shared metadata assets from the repository?

• A. DataStage Administrator
• B. Common Metadata Administrator
• C. Information Analyzer User
• D. Common Metadata User
• E. Business Glossary Administrator

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

• A. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.
• B. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.
• C. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.
• D. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.

You are responsible for the projects Source Code Repository. When a developer notifies you that changes are ready to deploy you must first check them in. You will use the Information Server Source Code integration features to check in the changed assets. How will you identify the DataStage assets the developer modified in order to send them to the workspace?

• A. From the workspace perspective select the project Right-click then Refresh from repository, specify a modification date and the developer's username in the Modified by fields.
• B. Use Designer client Advanced Find, specify a modification date and the developer's username in the Modified by fields.
• C. From the Information Server Manager Select the project then right-click on Synchronize with source code control system.
• D. From Information Server Manager use Search with advanced options, specify a date modified and the developer's user name in the Modified by fields.