|
Data Warehouse |
|
|
[SSIS] |
|
|
Questions: |
Notes: |
|
What is a Data Flow Task? |
A task which enables you to extract and transform data from various sources and load them to an array of destinations such as relational databases, flat files, and XML.
The data flow task also allows you to apply several out of the box transformations as well as custom transformations to your data.
This task is the primary task in any ETL strategy as well as package when populating data warehouses and data marts. |
|
What is the main purpose of SSIS? |
SSIS is a tool which enables developers to quickly develop ETL packages to populate data warehouses and data marts however SSIS is not limited to these tasks.
It is a tool which can create database executables and schedule them with less effort and less code. |
|
Can SSIS only read from SQL Server data types? |
No, SSIS can use source and target locations of many different file types and database management systems. Examples include Microsoft Office Excel spreadsheets, Flat File (Text Based Data), Extensible Markup Language (XML), and others. |
|
What is Business Intelligence? |
Business intelligence is the process of using information already available in your company in order to make better and faster business decisions. |
|
What are Data Tasks sources called? |
Data task sources are called Data Source Adaptors. |
|
What are Aggregate Transformations? |
Aggregate is a blocking transformation.
From the data in your source, every single record is extracted and then put into the aggregation functions. |
|
What is an SSIS package? |
An SSIS package is the highest-level object within an SSIS application. A package is a discrete unit of work that you define for ETL operations or SQL Server Services administration operations or both. It is a collection of SSIS process control components and their objects that define the operations, process dependencies, and sequence flow of activities and operations required for a data integration application. |
