Sparse lookup failed on different data type.
Posted: Fri Jun 28, 2013 4:32 pm
Hello ,
I was tryng to do a sparse lookup, the column in table is decimal and the orchestarte column i am passing is varchar.The reason i am passing varchar is, i need to simulate (RT.ID) IN (1093,1094) in query as (RT.ID) IN (ORCHESTRATE.Input). From input i am getting 1093,1094 as varchar in single column, to perform IN operation. where ID is decimal.
Datastage is expecting the ORCHESTRATE column to be as decimal. Throwing out error and aborting job.
Error:
Un-handled conversion error on field "ID " from source type "string" to destination type "decimal[10,0]":
source value="1093,1094 "; the result is non-nullable and there is no handle_null to specify a default value.
Any ideas how to achieve this.
Thank You
I was tryng to do a sparse lookup, the column in table is decimal and the orchestarte column i am passing is varchar.The reason i am passing varchar is, i need to simulate (RT.ID) IN (1093,1094) in query as (RT.ID) IN (ORCHESTRATE.Input). From input i am getting 1093,1094 as varchar in single column, to perform IN operation. where ID is decimal.
Datastage is expecting the ORCHESTRATE column to be as decimal. Throwing out error and aborting job.
Error:
Un-handled conversion error on field "ID " from source type "string" to destination type "decimal[10,0]":
source value="1093,1094 "; the result is non-nullable and there is no handle_null to specify a default value.
Any ideas how to achieve this.
Thank You