The design environment of SSIS includes an element that is
used to provide a tree view to the components in a package. Which element is
You should examine the
source data your solution uses before you start implementing an ETL. Give 3
reasons why this should be done.
A profile request that reports groupings of distinct values in a column.
The data destination
component of a data flow supports several destination types. List any two (2).
When optimizing the
performance of a data flow, one of the techniques is to set the default buffer
size to ___________.
_______________________ technique sufficient rows of memory have been read, they
will pass on to the next task.
When mapping columns, SSIS will make the best guess to automatically map columns with similar names in the source and destination.
You can define data
connections by creating _____________________________ for each data source
component and each destination component used in the workflow.
An SSIS control flow task that is responsible for executing packages and process.
An SSIS control flow
task that is responsible for checking database integrity, history cleanup,
backup databases, etc...
One of the benefits of dividing your solution into multiple packages:
List the three conditions which can define precedence constraints
Get Free Quote!
293 Experts Online