DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
RahulChandra
Participant



Joined: 22 Feb 2010
Posts: 2

Points: 24

Post Posted: Mon Feb 22, 2010 4:21 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
I am creating a Parallel job using Change Capture Stage. SQL Server(source stage), Oracle (target stage)
I like change capture to do a insert when there is a insert(working)
update when there is a delete (not working)
update when there is a update(working)
Please let me know how I can achieve this.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42926
Location: Denver, CO
Points: 221381

Post Posted: Mon Feb 22, 2010 4:24 pm Reply with quote    Back to top    

First step would be to re-post your question in the correct forum. For PX questions, that would be the Enterprise Edition forum. This one is for TX questions, a completely different product.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
abhijain
Participant



Joined: 13 Jun 2007
Posts: 88
Location: India
Points: 513

Post Posted: Tue Feb 23, 2010 6:08 am Reply with quote    Back to top    

Quote:
'update when there is a delete'

Change capture performs delete when there is a delete ideally. It does what it is supposed to do.

Alternatively, you can validate the value of change_code=2(Delete) in filter/transformer stage after change capture and can perform the update operation.

_________________
Rgrds,
Abhi
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42926
Location: Denver, CO
Points: 221381

Post Posted: Tue Feb 23, 2010 6:15 am Reply with quote    Back to top    

[sigh]

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54501
Location: Sydney, Australia
Points: 295558

Post Posted: Tue Feb 23, 2010 3:45 pm Reply with quote    Back to top    

There is no Change Capture stage in WebSphere Transformation Extender (formerly known as DataStage TX). If you post in the correct forum, you might receive more cogent answers.

If you post the same question in multiple fora, you will get exasperated answers from regular posters, who reasonably consider that such behaviour wastes their time.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



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