This wizard is used to define metadata about an output data set or OLAP cube.
What is the Target Designer wizard?
100
It is a transform that enables the creation of SQL queries.
What is the SQL Join transform?
100
It is a SAS program that is hosted on a server, described by metadata, and can be executed by many of the clients in the SAS Intelligence Platform.
What is a Stored Process?
200
It stores information about how to connect to the Metadata Server from an application such as DI Studio.
What is a Metadata Profile?
200
It is the wizard used to create a user defined transformation.
What is the Transformation Generator wizard?
200
It is a transform used to specify error conditions and actions to take when the error conditions occur.
What is the Data Validation transform?
300
This Tree View tab in DI Studio lists the typical table level transformations to be used in an ETL process.
What is the Process Library tab?
300
DAILY DOUBLE: These are the two options for location of the code in the properties of the User Written Code transform.
What are Metadata and File?
300
It is a tab in the properties of a Job used to specify user-written code to be inserted at the beginning or end of the current job.
What is the Pre and Post Process tab?
400
It is the only type of repository that enables adding or updating metadata under change management.
What is a Project repository?
400
It is a tab in the properties of the Table Loader transform that enables the specification of a load style. (Hint: The three available load styles are: Append to Existing, Replace, Update/Insert)
What is the Load Technique tab?
400
This activity is performed in order to identify the tables or columns, jobs, and transformations that contribute to the content of a selected table or column.
What is Reverse Impact Analysis?
500
These are the types of raw data source files that can be defined using the Source Designer wizard. (At least two)
What are Delimited and Fixed Width files?
500
It is a table containing rows of data that can be fed into an iteration for use in a Loop transform.
What is a Control Table?
500
This are three options for directing the output of a stored process, which are specified during its creation in the Stored Process Wizard.
What are Streaming, Transient Package, and Permanent Package?