DataStage
文章平均质量分 73
junli0310
DBA
展开
-
如何解决Datastage端口不能释放的问题
今天楼下项目组的manager踢掉了电源,导致正在做开发的几台机突然从主机断开。可惜的是他们没有通过DataStageDirector中杀掉刚才的连接,而是选择重启datastage服务,这样一来,监听端口没有释放,服务再次启动后不可用。 以前经常碰到类似的问题,一般情况下重启机器就可以释放。但是这次工作紧而且服务器上又有其他项目的应用正在被使用,无法重新启动。经过半个多小时的摸转载 2008-09-18 21:41:00 · 3866 阅读 · 0 评论 -
DATASTAGE——Surrogate Key Stage用法
功能:产生自增字段。 The Surrogate Key stage generates key columnsfor an existing data set. You can specify certain characteristics ofthe key sequence. The stage generates sequentially incrementing转载 2008-09-18 19:45:00 · 1889 阅读 · 0 评论 -
DATASTAGE——一DATASTAGE经验积累
一、JOB的分类与作用(?) 1、Server JOB: 最为常用的Job类型,Job可以组合使用,Server Job是Job的最小单位。 原文档:If you have the Web Services pack installed an additional check box, Web Service Enabled, appears. Sele转载 2008-09-18 19:44:00 · 2532 阅读 · 0 评论 -
How to Create, Use and Maintain DataStage 8 Parameter Sets
This is a three part DataStage tutorial on using the new version 8Parameter Set functionality that shows how it works and adds somepractical advice for how to use it.DataStage 8.0.1 came with转载 2008-09-19 23:30:00 · 3290 阅读 · 0 评论 -
What is new for DataStage 8 on the Information Server
DataStage 8 on the Information Server looks the same as previousreleases but has some major changes under the hood and a few extrabells and whistles.This post looks at what is new or changed in转载 2008-09-19 17:26:00 · 3740 阅读 · 0 评论 -
DataStage tip: using job parameters without losing your mind
A job parameter in the ETL environment is much like a parameter inother products, it lets you change the way your programs behave atrun-time by tweaking or changing parameters to alter the way th转载 2008-09-19 17:18:00 · 1653 阅读 · 0 评论 -
DataStage Certification - how to pass the exam
I am officially a certified DataStage something or other. After twohours sitting in a small biege room using nothing but a mouse I pickedup an 88% score and certification. Now I have a headache.转载 2008-09-19 17:17:00 · 1351 阅读 · 0 评论 -
End of the "Road to DataStage Certification" D
I feel very happy at the end of my journey :D (So, unfortunate thatthere are no emoticons in blogger ;) ). I finally("finally", because Ihave been planning to take this for a long time now) clear转载 2008-09-19 17:13:00 · 1210 阅读 · 0 评论 -
DATASTAGE——Hashed file stage使用
原文档:Hashed File stages represent a hashed file, i.e., a file that usesa hashing algorithm for distributing records in one or more groups ondisk. You can use a Hashed File stage to extract or writ转载 2008-09-18 19:44:00 · 1310 阅读 · 0 评论 -
DATASTAGE——关于数据分区的概述
Partitioning The aim of most partitioning operations is to end up with a set of partitionsthat are as near equal size as possible, ensuring an even load across yourprocessors. When perfor原创 2008-09-18 19:42:00 · 1647 阅读 · 0 评论 -
DataStage(ETL)技术总结 -- 介绍篇
数据整合的核心内容是从数据源中抽取数据,然后对这些数据进行转化,最终加载的目标数据库或者数据仓库中去,这也就是我们通常所说的 ETL 过程(Extract,Transform, Load)。 IBM WebSphere DataStage(下面简称为DataStage)为整个 ETL 过程提供了一个图形化的开发环境,它是一套专门对多种操作数据源的数据抽取、转换和维护过程进行简化和自动化,转载 2008-09-18 19:40:00 · 1412 阅读 · 0 评论 -
WebSphere DataStage Enterprise Edition 实践 并行访问多节点 DB2 的配置与实现
DataStage EE 中的DB2 Stage在DataStage EE中提供了三种关于DB2 的Stage,忽略ODBC,加上Dynamic RDBMSStage,我们有四种Stage可以存取DB2数据库,其中只有DB2/UDB EnterpriseStage支持并行访问带分区功能的数据库,它是通过特别的架构来实现DB2的并行访问,稍候我们会详细介绍。 图1:Dat转载 2008-09-18 19:51:00 · 4600 阅读 · 0 评论 -
101 uses for ETL job parameters
This is my third post in what I am now calling job parameter week. Infuture it will be better if I come up with an idea for a theme week atthe start of the week instead of the end of the week. I转载 2008-09-19 17:18:00 · 1063 阅读 · 0 评论 -
DataStage Parallel routines made really easy
DataStage is a powerful ETL tool with lot of inbuilt stages/routineswhich can do most of the functionalities required; for those thingsDataStage EE can’t do, there are parallel routines which c转载 2008-09-19 17:11:00 · 1489 阅读 · 0 评论 -
Configure DB2 remote connectivity with WebSphere DataStage Enterprise Edition
Introduction WebSphere DataStage is one the foremost leaders in the ETL (Extract,Transform, and Load) market space. One of the great advantages of thistool is its scalability, as it is capa转载 2008-09-19 17:06:00 · 3861 阅读 · 0 评论 -
DataStage 7.x 权限控制
DataStage 7.x 权限控制 <!-- <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:dc="http://purl.org/dc/elements/1.1/"转载 2008-09-27 10:16:00 · 1504 阅读 · 0 评论