Transform Map is not working

sam352120
Kilo Guru

Hi All,

I have created one Data source of JDBC type,   which is able to load data into Import set table using "Test load 20 Record".

My problem is the transform map is not working properly , I can see the data source is populating   data to import set table but the data is not populating in my target table.

I have tried with direct field mapping also I have tried with transform script , both are not working, I used some log and found out error as source and target is undefined but in my transform map both source_table and target_table has proper table name.

please share your idea.

17 REPLIES 17

Mujtaba Amin Bh
Mega Guru

Send a screen shot of your transform map.


find_real_file.pngfind_real_file.png


this is the transform map.


Hi sambit,



is the source table "u_citicus_qa_db" an import set table?


do you have any acl which restricts the user from inserting into that   target table?