-
编辑 删除
SQL NULL
What is NULL? NULL represents the absence of a value. Technically it is not a value in itself. However we often use the phrase "NULL value".But then we also use database ...
-
编辑 删除
production support
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
K shell Operators
touch test vi test 编辑脚本 test #!/bin/ksh who |wc -l rmdir test.1 ...
-
编辑 删除
finacial knowledge
从最基本的securities学起。equity, bond, 它们的异同，关系，等等。。然后，再了解一下investment, risk, cash flow, libor, shibor, security exchange, OCT, FX trading, leverage, ...这些基本概念，就可...
-
编辑 删除
递归打印数字
USE [Test]GO/****** Object: StoredProcedure [dbo].[sp_test] Script. Date: 06/20/2012 22:23:22 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[sp_test] @le...
-
编辑 删除
Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
Contributors: Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers: Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay MishraBuilding a large scale relational data w...
-
编辑 删除
c# 螺旋矩阵
static void Main(string[] args) { int i, j; // &nbs...
-
编辑 删除
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 ...
-
编辑 删除
工资比经理高且不是经理的员工
select a.*,b.* from T1 a, T1 b where a.id=b.manageridand a.salary < b.salaryand b.id not in (select managerid from T1 WHERE managerid IS NOT NULL)
-
编辑 删除
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...
-
编辑 删除
id 连续,name 一样的, value 加和
create table etltable(name varchar(20) ,seq integer,money integer);create table etltarget (name varchar(20),min_s integer,max_s integer,sum_money integer);insert into etltable values ('A',1,100)...
-
编辑 删除
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...
-
编辑 删除
MS SQL Server查询优化方法
1.如果是使用like进行查询的话，简单的使用index是不行的，但是全文索引，耗空间。 like 'a%' 使用索引 like '%a' 不使用索引用 like '%a%' 查询...
-
编辑 删除
SAP的BI产品线一览（转）
一：SAP大会的主要内容(BI相关)：1.1：事件： 68亿美元收购BO大会有10%的讲座和实践课涉及BO，主题演讲的演示使用了BO的Xcelsuis，大会重要主题: BO与SAP的整合。1.2：配合：SAP与BO产品线互相促进讲到了NetWeave与B...
-
编辑 删除
Intermediate Crystal Reports XI Training
Intermediate Crystal Reports XI Training ObjectivesAll attendees will learn how to:Create and format multiple report sectionsUse running totalsPrompt with parametersUse advanced formulasCreate subrepo...
-
编辑 删除
Crystal report training
Crystal Reports XI Training PrerequisitesAll attendees should have basic familiarity with at least one relational database such as Microsoft Access, SQL Server, MySQL, Oracle, Sybase, or DB2.Hands-on/...
