Integer to Decimal change

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
gooogle
Participant
Posts: 42
Joined: Tue Feb 23, 2010 3:40 pm

Integer to Decimal change

Post by gooogle »

I changed a column type from Integer to Decimal for
SQl table A Source & SQL table B Target
1st I changed the table definations for both tables [Integer to Decimal]
2nd I manually typed inside the transfomer for both [Integer to Decimal]

I am getting this warning now:
(componentNumericValue) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Decimal

How to get rid of this warning ?

Thanks
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

IMPORT the table definition again. Check what comes in as data type for the modified field?
You are the creator of your destiny - Swami Vivekananda
Post Reply