-
编辑 删除
SSIS --Slowly Changing Dimension
Surrogate KeysAlso known as meaningless keys, substitute keys, non-natural keys, or artificial keys. A surrogate key is a unique value, usually an integer, assigned to each row in the dimension. This ...
-
编辑 删除
BI Interview Questions
Recently I had to find a BI resource to do some ETL work for me. I wanted to make sure I had the right person for the job so I came up with a list of interview questions that pro...
-
编辑 删除
SSIS Result Sets in the Execute SQL Task
The Execute SQL task supports the following types of result sets: The None result set is used when the query returns no results. For example, this result set is used for queri...
-
编辑 删除
SSIS display null in destination file
I suggest you can use string "Null" instead of "NULL" using Derived Column Transformation, and then load the data to Excel Destination. Please refer to the steps about configuring the Derived ...
-
编辑 删除
ssis multiple table to one file
First, if the metadata is different. It does not work with union all .So,Why not just have 3 dataflow tasks one for each table with precedence constraints to have them execute in the correct o...
-
编辑 删除
ssis export one table to multiple files
The following question was posed on the SSIS forum recently:I have a table with 25 Million records. I want to transfer the records from the table to flat files. One flat file can contain onl...
-
编辑 删除
Exporting data from multiple SQL tables to flat files using SSIS
SELECT name FROM sysobjects WHERE type = 'U'SELECT name FROM sys.columns WHERE (object_id = OBJECT_ID('test1'))S...
-
编辑 删除
数据仓库面试资料(基本概念)（转）
什么叫数据仓库？ 数据仓库是一个面向主题的（SubjectOriented）、集成的（Integrate）、相对稳定的（Non-Volatile）、反映历史变化（TimeVariant）的数据集合，它用于支持企业或组织的决策分析处理。数据仓...
