DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 5 matches
Author Message
 Topic: How to prevent datastage jobs from retrieving source info?
jason2018

Replies: 3
Views: 430

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Aug 04, 2018 2:38 am   Subject: How to prevent datastage jobs from retrieving source info?
thanks for replying. I tried that before, both, but didn't work. You get my point, I want to define the "keys" on my own, even if there is no unique constraints on the source table
 Topic: How to prevent datastage jobs from retrieving source info?
jason2018

Replies: 3
Views: 430

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 20, 2018 4:33 am   Subject: How to prevent datastage jobs from retrieving source info?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: "source info" means table reference info of data source
I found that datastage jobs would detect the source table, retrieving information through the connector like db2 and informix connector, not just execute by the properties of fields I defined in the " ...
 Topic: A weird problem with Change Capture stage
jason2018

Replies: 7
Views: 1086

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 11, 2018 8:32 pm   Subject: A weird problem with Change Capture stage
the official support expired
 Topic: A weird problem with Change Capture stage
jason2018

Replies: 7
Views: 1086

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 10, 2018 11:45 pm   Subject: A weird problem with Change Capture stage
there is not any overlap between the keys and the values. I've checked
that for several times.
I asked this question on stackoverflow too, but not get a solution until now
 Topic: A weird problem with Change Capture stage
jason2018

Replies: 7
Views: 1086

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 03, 2018 9:10 pm   Subject: A weird problem with Change Capture stage
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Change_Capture: A field cannot be both a key and a value.
I design a parallel job with change capture, and my stage properties setting as follow:

exclude values: some fields I don't want to compare
change keys: fields as keys
options:
change mode=Expli ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours