Chnage capture issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
India2000
Participant
Posts: 274
Joined: Sun Aug 22, 2010 11:07 am

Chnage capture issue

Post by India2000 »

In change capture stage if we are exckuding any columns it shouldn't be used in comparison for updates.I have a scenrio where after excluding a a column will used in comparing columns for update resords. could anyone tell me the reason for it? is it the descrepance in datastage change caprture stage orsomething else is going wrong here?
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

more specific information would be helpful
- Zulfi
kamtammystuff
Participant
Posts: 26
Joined: Fri Feb 19, 2010 2:08 am

Re: Chnage capture issue

Post by kamtammystuff »

India2000 wrote:In change capture stage if we are exckuding any columns it shouldn't be used in comparison for updates.I have a scenrio where after excluding a a column will used in comparing columns for update resords. could anyone tell me the reason for it? is it the descrepance in datastage change caprture stage orsomething else is going wrong here?
Do spell check before you post anything.. !!!

To answer your question ..... If a column is not included in the change values category then that will not be compared.
_____________________________________
-Kish
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

You may have chosen the wrong Change mode setting in the stage, according to what you want. What do you have it set to?
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply