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 this?
computer science
Description
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
this?
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 ___________.
In
_______________________ 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
