- 博客(16)
- 资源 (36)
- 收藏
- 关注
原创 syscat.tables
SELECT TRIM(TABSCHEMA) || '.' || TABNAME FROM SYSCAT.TABLES WHERE TABSCHEMA = 'WH' AND TYPE = 'T' AND ( TABNAME like '%DIM' or TABNAME like '%MAP' or TABNAME like '%FACT' or TABNAME like '%S
2016-01-28 17:34:43 3366
原创 db2 current date
current dateSELECT *FROM dept t where t.rksj > (current date-1 days)
2016-01-27 11:20:57 4176
原创 解决db2 SQL30081N
Problem(Abstract)11041 - A database error occurred while attempting to open tableEDIENU32.EDIVTSIS, ODBC return code is: -1. Description: SQL30081N A communication error has been detected.
2016-01-27 09:44:52 19364
转载 db2 常用语句
查看表空间db2 list tablespaces show detail 1.2查看数据库的表死锁方法一:打开监控 db2 update monitor switches using lock on查看锁表 db2 get snapshot for locks on 数据库名称db2 "force application (handle id)"
2016-01-27 09:38:49 3492
原创 python quick start
1、running python#! /usr/bin/python python sc.py2、command line interptereripython3、core language elementsdef myfunc(source): retval = [] for item in source:
2016-01-26 11:27:26 510
原创 DB2 Runstats 抽样统计 sampled
runstats on table wh.employee with distribution on all columnsand detailed indexes all tablesample system (10); ----- 10 percent of the pagesrunstats on table wh.employee on all columnsand
2016-01-25 14:00:27 3935
转载 autosys 基本命令
AutoSys的基本命令1.cmd sendevent -E FORCE_STARTJOB -J JobNamesendevent -E JOB_ON_ICE -J JobNamesendevent -E CHANGE_STATUS -s FAILURE -J JobNamesendevent -E CHANGE_STATUS -s SUCCESS -J JobName
2016-01-21 20:03:27 3577
转载 如何提高英语学习
序本文是作者2009年在福州工作时给一些在英语学习中略窥门径,但不知如何提高的朋友的几点建议,在这里再次拿出来,供大家参考。文章的题目之所以叫“加减乘除”,因为当时是受公司HR部门委托,用“加减乘除”作一篇命题作文,阐述学习方法。当时文章的原文没有留档,只好重新写出来,保证原创。学习在于持之以恒和点滴积累,外语学习更是如此。有心人只要些许点拨就能找到适合自己的学习方法,而无心学习的
2016-01-07 10:47:35 617
转载 Slowly Change Dimention 常见三种类型
在从 OLTP 业务数据库向 DW 数据仓库抽取数据的过程中,特别是第一次导入之后的每一次增量抽取往往会遇到这样的问题:业务数据库中的一些数据发生了更改,到底要不要将这些变化也反映到数据仓库中?在数据仓库中,哪些数据应该随之变化,哪些可以不用变化?考虑到这些变化,在数据仓库中的维度表又应该如何设计以满足这些需要。很显然在业务数据库中数据的变化是非常自然和正常的,比如顾客的联系方式,手机号码等信
2016-01-07 09:44:56 513
翻译 Lookup Transformation(4) 可配置的特性
Lookup Transformation Properties Lookup组件有很多的可配置的特性。 决定于查找的数据源(文件或者关系型数据库)Lookup transformation has so many proprties which you can configure. Depending on the lookup source (flat file
2016-01-05 17:34:44 567
翻译 Lookup Transformation(3) changes in informatica version 9
Lookup Transformation is ActiveOne of the changes that made in informatica version 9 was making the lookup transformation as active transformation. The lookup transformation canreturn
2016-01-05 17:21:57 400
翻译 Lookup Transformation(2) 优化
Tuning Lookup Transformation - Informatica Q) How to tune lookup transformation to improve the performance of the mapping?This is a frequently asked question in informatica interview
2016-01-05 16:41:35 391
翻译 Lookup Transformation (1)
Lookup Transformation Lookup transformation is used to look up data in a flat file, relational table, view or synonym. Lookup is a passive/active transformation and can be used in both connected
2016-01-05 16:16:25 437
翻译 Joiner transformation(2) 优化
Joiner transformation 使用注意点:1)使用场景: 不同数据源( 异构源)2)Join type: Normal Join, Master Outer Join, Detail Outer Join or Full Outer Join.3) 用行数少的重复记录少的表为 master, 反之为detail4) 对输入项做排序5) 理解 blocking t
2016-01-05 14:48:16 504
翻译 Joiner Transformation(1)
The joiner transformation is an active and connected transformation used to join two heterogeneous sources. The joiner transformation joins sources based on a condition that matches one or more
2016-01-05 14:24:07 556
转载 informatica 基本组件使用说明
http://blog.itpub.net/29144194/viewspace-1141535/1. INFORMATICA CLIENT的使用1.1 Repository Manager 的使用1.1.1 创建Repository。前提: a. 在ODBC数据源管理器中新建一个数据源连接至你要创建Repository的数据库(例:jzjxdev)b. 要
2016-01-05 11:53:33 20975
Oracle-pexam_1Z0-060.docx
2021-09-12
redhat6.5 oracle ASM驱动
2016-04-27
SQL server compact 3.5
2012-12-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人