constraints
Posted: Mon Oct 08, 2001 7:17 pm
Hi all,
This is my first posting to the list. Pardon me if
this has been discussed.
I am loading the target table with one main source
table and few reference lookups.
I am looking for a surrugate key in one of the lookup
table that can give me null values. I am defining my
constraint so that if the ref. surrogate value is null
then reject it. (in1.lkupsuurkey ).
I am getting the error while running the job.
How is this type of situation handled otherwise in
datastage?
TIA
__________________________________________________
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
This is my first posting to the list. Pardon me if
this has been discussed.
I am loading the target table with one main source
table and few reference lookups.
I am looking for a surrugate key in one of the lookup
table that can give me null values. I am defining my
constraint so that if the ref. surrogate value is null
then reject it. (in1.lkupsuurkey ).
I am getting the error while running the job.
How is this type of situation handled otherwise in
datastage?
TIA
__________________________________________________
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1