how to create a import staging table

snowuser111
Kilo Guru

‎01-19-2018 02:04 AM

Hi Community,

I want to create a transform map and want to select a source table . How do I create a staging table . I tried creating a table from tables and columns but i do not get that table in the source table list.

0 Helpfuls
  • 4,994 Views
4 REPLIES 4

Ashutosh Munot1
Kilo Patron
Kilo Patron

‎01-19-2018 02:08 AM

HI ,



That table should extend import set table. Then it will be visible there.


What i suggest is create a data source and give table name there. Source table will be automatically get created for you.



So to this Data source you can create transform map.


0 Helpfuls

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

‎01-19-2018 02:09 AM

Create a data source, that will create automatically the staging table.


0 Helpfuls

Jaspal Singh
Mega Patron
Mega Patron

‎01-19-2018 02:24 AM

Hi ,



Make sure you select extends as Import Set Row for the table created. Once done it would then be available for selection as staging table.


Mohammad8
Kilo Expert

‎11-05-2018 06:35 AM

I tried to create a data source and I also tried to created a table and make it extend "import set row" but neither of these way worked. I must be missing something. Any suggestions?

0 Helpfuls