You are developing a SQL Server Integration Services (SSIS) package. The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data…

Question

Options

• AMulticast
• BData Conversion
• CLookup
• DSlowly Changing Dimension
• EAggregate

• A
  85% (22)
• B
  8% (2)
• D
  4% (1)
• E
  4% (1)

Explanation

A: The transformation that distributes data sets to multiple outputs. The transformation that distributes data sets to multiple outputs. C: Lookup Transformation The transformation that looks up values in a reference table using an exact match. - SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations load data into data stores or create in-memory Not B: Data Conversion Transformation The transformation that converts the data type of a column to a different data type. Not D: Slowly Changing Dimension Transformation The transformation that configures the updating of a slowly changing dimension. Not E: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across.

No community discussion yet for this question.