为 InfoSphere Warehouse 提供实时数据的高效解决方案

DataStage 作业开发

通过使用 Event Publisher, 我们可以把数据表里由于 DML 操作发生的数据变化实时放入到 MQ 消息队列中，它将生成如下的消息：

清单 7. Event Publisher 生成的 MQ 消息示例

　10,"IBM","2010098","181602875000","DEMO","CUSTOMER",　
　"ISRT","0000:0000:0000:0000:5914","0000:0000:0000:04f2:d60f",　
　"2010-04-08-17.16.02",,0000,,,,,,,,,,,,,,9000,"F",　
　"1960-05-06-00.00.00.000000","467897085","Boise","Idaho",　
　"83701-83733","(71)657-9085","English","2006-08-18-21.52.29.000000",　
　"IRVING","H","STERN"　
　
　10,"IBM","2010098","181603343000","DEMO","CUSTOMER",　
　"REPL","0000:0000:0000:0000:5916","0000:0000:0000:04f2:daaf",　
　"2010-04-08-17.16.02",,0000,2075,"F","1950-04-16-20.45.00.000000",　
　"205674075","Atlantaa","Georgia","30302-30399","(206)567-6075",　
　"English","2007-04-19-20.45.00.000000","SALLY","",　
　"STERN",5000,"F","1950-04-16-20.45.00.000000","205674075",　
　"Atlantaa","Georgia","30302-30399","(206)567-6075",　
　"English","2007-04-19-20.45.00.000000","SALLY","","STERN"　
　
　10,"IBM","2010098","181603343000","DEMO","CUSTOMER",　
　"DLET","0000:0000:0000:0000:591a","0000:0000:0000:04f2:f768",　
　"2010-04-08-17.16.02",,0000,8354,"F","2009-07-06-00.00.00.000000",　
　"34124","Beijing","fadsfs","10083","13439097809","Chinese",　
　"2009-07-28-00.00.00.000000","","","SHI　LIXIAN",,,,,,,,,,,,,