determine import set data source

kjmauriello
Mega Expert

I am in a clients instance, the cmn_location table is being loaded via import set every night between 12-1am.

I see the transform map, the import set but cannot find what the data source is.

I am trying to determine how the data is coming into the instance.

I have also looked at scheduled jobs and scheduled imports.

Is there a way for me to determine what the data source/web service is for a particular import set?

Thank you

1 ACCEPTED SOLUTION

ghsrikanth
Tera Guru

Hi kevin,



Please go to the sys_data_source table and you can see there are two columns import set label and import set table


you can query your table there as you said you know the import set table -


Screen Shot 2016-04-01 at 8.01.59 PM.png



Hopefully this helps


View solution in original post

2 REPLIES 2

ghsrikanth
Tera Guru

Hi kevin,



Please go to the sys_data_source table and you can see there are two columns import set label and import set table


you can query your table there as you said you know the import set table -


Screen Shot 2016-04-01 at 8.01.59 PM.png



Hopefully this helps


That helped thank you, unfortunately the web service did not exist