Hi all,Please help me ,I am using kettle 3.2 , Working on dimension and fact table data population, My source data query is SELECT (SELECT C.DESCRIPTION FROM NBFC_PRODUCTTYPE_M C WHERE B.PRODUCTTYPE=C.PRODUCTTYPEID) PRODUCT_SUBCATEGORY_NAME,(SELECT PROMOTIONID FROM LEA_PROMOTION_M D WHERE D.SCHEMEID=A.SCHEMEID) PROMOTION_ID,(SELECT PROMOTIONDESC FROM LEA_PROMOTION_M E WHERE E.SCHEMEID=A.SCHEMEID) PROMOTIONDESC,B.PRODUCTTYPE,B.CODE,B.DESCRIPTION,B.START_DT,B.END_DT,B.EXPOSURE_LIMIT,A.SCHEMEID SCHEME_ID,A.SCHEMEDESC,A.MAXTENURE,A.MINTENURE,A.MAXINTRATE,A.MININTRATE,A.SCHEME_START_DATE,A.SCHEME_END_DATEFROM LEA_SCHEME_M A RIGHT OUTER JOIN NBFC_PRODUCT_M BON (A.PRODUCTFLAG=B.CODE) and i have mapped it with target table columns by using "source data" ------>"select values"-------->"dimension lookup" to populate data in product_dimension table. product_dimension table stru is PRODUCT_KEY NOT NULL NUMBER PRODUCT_SUBCATEGORY_ID VARCHAR2(1)PRODUCT_SUBCATEGORY_NAME VARCHAR2(50)PRODUCT_ID VARCHAR2(8) PRODUCT_NAME VARCHAR2(35)SCHEME_ID NUMBER(8) SCHEME_NAME VARCHAR2(35)PROMOTION_ID NUMBER(8) PROMOTION_DESC VARCHAR2(35)MAX_TENURE_SCHEME NUMBER(3) MIN_TENURE_SCHEME NUMBER(3) MAX_INT_SCHEME NUMBER(5,2) MIN_INT_SCHEME NUMBER(5,2) EXPOSURE_LIMIT NUMBER(18,4)EXPOSED_LIMIT NUMBER(18,4)START_DT DATE END_DATE DATE SCHEME_ST_DATE DATE SCHEME_END_DATE DATE VERSION_ID NUMBER EFFECTIVE_DATE DATE EXPIRATION_DATE DATE when i am running transformation it is returning an error PROMOTION_ID Integer(8) : There was a data type error: the data type of java.math.BigDecimal object [3] does not correspond to value meta [Integer(8)]source and target have same column datatype of number(8).Please help me to resolve this. 2012/06/28 11:23:11 - PRODUCT DIMENSION LOOKUP.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1591)2012/06/28 11:23:11 - PRODUCT DIMENSION LOOKUP.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.RuntimeException: PROMOTION_ID Integer(8) : There was a data type error: the data type of java.math.BigDecimal object [3] does not correspond to value meta [Integer(8)]