Hello,
One of the column of Oracle table changes from number(5,2) to number(10,2). Should I change the table definition accordingly in data stage? I have a feeling that data stage does not need to change. Since I do not have access to data stage currently, I can not test it out. Can some one tell me if data stage should change the table definition on the column? Thanks
Table Column Definition
Moderators: chulett, rschirm, roy
Table Column Definition
Regards
Jie
Jie
From what I recall, you'll need to change it. DataStage enforces field sizes at the target, so while it won't care as it flows through the job, it will check just before it sends the data to the target. If it sees something larger than your internal metadata allows, pretty sure that you'll get a message to that effect and it will send a null in its place.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers