Hi All
I have REST Connection from ServiceNow (SN) to Qlik Sense. The source table on SN has got only 10K rows. however when I am loading data in qlik it is taking more than 30 minutes. I have setup all pagination information to load 5K instance at a time. Also one more thing the JASON script created to load data is taking creating cross table with every field I am trying to load from data.
Example :
I have EMP table in SN with 10K records with 10 fields:
When jason script is created in QS, it has got 10 select statement. like
RestConnectorMasterTable:
SQL SELECT
"__KEY_result",
(SELECT
"display_value",
"value",
"__FK_u_EMPID"
FROM "u_EMPID" FK "__FK_EMPID"),
Similarly, 10 selects statements are created to load data. This is creating cross joins and impacting the load. so wanted to know is there any way to reduce load time.
