Thanks for your suggestion.
Outside datastage it is giving expected value.(0.45)
What would be the difference in decimal(31,5) to decimal(31,7) if the value is 0.45 only.
Search found 7 matches
- Tue Nov 28, 2017 11:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
- Wed Nov 22, 2017 4:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
Re: Schema reconciliation detected a size mismatch for colum
Yes I am casting externally in SQL query. select cast(col as decimal(31,5)) ; and i defined decimal(31,5) in teradata connector. but i am getting warning Schema reconciliation detected a size mismatch for column col1. When reading database column DECIMAL(31,5) into column DECIMAL(31,0), truncation, ...
- Thu Nov 16, 2017 3:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
Re: Schema reconciliation detected a size mismatch for colum
The source value in DB is 0.45 the value coming out is 0.00
- Thu Nov 16, 2017 2:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
Re: Schema reconciliation detected a size mismatch for colum
sriven786,
Thanks For your suggestion.
Actually i have decimal(18,7) in database table and i am casting to decimal(31,5) and the same decimal(31,5) is defined in medatadata of the conenctor. The job is running fine 9.1 it is only getting aborted in 11.3. Do we need to cahnge anything ?
Thanks For your suggestion.
Actually i have decimal(18,7) in database table and i am casting to decimal(31,5) and the same decimal(31,5) is defined in medatadata of the conenctor. The job is running fine 9.1 it is only getting aborted in 11.3. Do we need to cahnge anything ?
- Tue Nov 14, 2017 9:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
- Tue Nov 14, 2017 9:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
Re: Schema reconciliation detected a size mismatch for colum
I am using teradata connector stage. Fail on type mismatch is already set to NO. Job is not getting aborted but data is getting truncated.
- Tue Nov 14, 2017 1:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16683
Schema reconciliation detected a size mismatch for column
Hi , I am getting below error and data is getting truncated in 11.3 where as in 9.1 the job is running fine. ID_ACT_Excl_Fact,0: Schema reconciliation detected a size mismatch for column columnname. When reading database column DECIMAL(31,5) into column DECIMAL(31,0), trunca tion, loss of pre (...) ...