-
编辑 删除
正则表达式Sed
绝对match查找 ： grep -w ab 2.txt 结果只有ab会打印出来sed -n '/\ba\b/p' 2.txt 结果只有a会打印出来 绝对匹配1. Sed简介sed 是一种在线编辑器，它一次处理一行内容。处理时，...
-
编辑 删除
Morgan Stanley
df|grep run|awk '{print $5}'|sed 's/%//g' sed [options] 'command' file(s) sed [options] -f scriptfile file(s) awk ' pattern {actio...
-
编辑 删除
常用查看Linux系统信息命令
系统# uname -a # 查看内核/操作系统/CPU信息# head -n 1 /etc/issue # 查看操作系统版本# cat /proc/cpuinfo # 查看CPU信息# hostname # 查看计算机名# lspci -tv ...
-
编辑 删除
UNIX Quick Reference Sheet
control-zStop (don't kill) the foreground job, and then return to the shelljobsCheck the status of jobs in the current sessionps -u usernameCheck the status of processes, including those from...
-
编辑 删除
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...
