Integration HUB ETL staging table having empty fields

pratiksha5
Mega Sage

I am trying to populate data with integration hub ETL class printer. 

 

I created one data source when I am loading the data cost is not getting populated in -prepare source data for mapping

 

 

 

I changed the data type from decimal to currency when I loaded the data in data source I can see the data in import set table. But in prepare source data for mapping it is not coming up. 

 

Please help 

 
 

 

 

12 REPLIES 12

@pratiksha5 

you are not using Transform map for this?

Can you not add transform script to it?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

We are loading data in CMDB. Integraion hub ETL is the ideal tool for that. It calls IRE by default. 

 

@pratiksha5 

I haven't worked on it.

But if you are having option to script then you need to use the above syntax to set the currency value.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader