Run ILG (Steps 13-15)

DEPENDENCIES:

• Final approval after GSI Review received or imminent.

OVERVIEW:

Run ILG. Since ILG can take a long time to complete, it is usually beneficial to run ILG early while the final SWXL is still being reviewed and approved. After final approval, if there are no changes then we will already have ILG complete and save many hours of waiting.

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/URLPriority/note.txt

PROCESS:

13. Generate ILG: Run script to generate relations. It could take about 10-15 hours for a mid-size POS. May need to run when server is not under high load.

exec up.usp_url_swxl @url_swxl_parameter_id = @url_swxl_parameter_id;

14. More QA, make sure results in up.URL_SWXL_Relation are the same as specified in up.URL_Link and up.KW_Link

15. At this point, one can proceed with the same scripts noted in KW-based SWXL

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/qa/ILG_QA_Report.sql

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/util/execute-usp-generate-swxl-tables.sql

NOTES:

• Small Points of Sale typically take about 5 hours.
• Large Points of Sale could take 8 hours or more.
• For status, check the up.URL_SWXL_Status table.