Had to change the expression of the age_constraint using this conversion: TO_NUMBER(CLIENT.AGE , '99.9)

1) For ODI 11.1.1.7 instead of: <ODI_HOME>/demo/xml/GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true use: jdbc:snps:xml?f=<ODI_DEMO_HOME>\xml\GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true for sample: jdbc:snps:xml?f=C:\odi_demo\xml\GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true 2) Instead of: RDBMS_TARGET > CLIENT > Constraints > CITY Copy of CITY_CLIENT read: RDBMS_TARGET > CLIENT > Constraints > CITY

-

-