Table Column Definition

jiegao · Post by **jiegao** » Thu Mar 08, 2012 1:35 pm

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

chulett · Post by **chulett** » Thu Mar 08, 2012 1:57 pm

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.

chulett · Post by **chulett** » Thu Mar 08, 2012 2:09 pm

Note that since you marked your post with a job type of Server I moved it to the Server forum and gave you a Server answer.

qt_ky · Post by **qt_ky** » Thu Mar 08, 2012 10:36 pm

Server jobs are more forgiving of metadata mismatches than Parallel jobs. You should plan to change it as a best practice, even if it gives correct results as is.

chulett · Post by **chulett** » Fri Mar 09, 2012 7:41 am

Forgiving in job, yes, but still enforce everything at the target.

jiegao · Post by **jiegao** » Fri Mar 09, 2012 12:15 pm

Thanks