Transform Map is not working

[sam352120]

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.

[Mujtaba Amin Bh]

Can you share xml of one the records from the import set table?

[sam352120]

Please check I have attached the xml file of one record from import set table   by data source.

[Mujtaba Amin Bh]

It looks fine. Can you compare it with xml of one of the records that you created manually in the import set table and see if something is missing.

[chaitanyakumar]

I have same issue but i am trying to create new OU definition to import all the deactivated users from AD and make them inactivate in instance ,I have created new data source and using the existing staging table, When i am testing with 20 Records and users records importing to source table but no update on the target table

That's my Transform script. Here is my OnBefore script

Can anyone share your ideas?

Thanks,

Chaitanya

[martygrinstead]

Hi Chaitanya,

Test loading 20 records is good to make sure you data source is configured correctly, and that the source table can be populated correctly.   But, the transform map is designed to NOT process "test" records.   You can do a full load and then transform the new data.

There is a KB that discusses this:   KB0563963

Marty