Bring the E2E tables from UDH for historic KFs logic update - Purchase Order table

Truncation mode to be used now.

analysis :

1)created ssis pacakges

518(1)_imp_SNOWFLAKE_ECC_PURCHASE_ORDER_to_OSCAR_DATA.dtsx

518(2)_imp_SNOWFLAKE_ECC_PURCHASE_ORDER_to_OSCAR.dtsx

2)created below tables :

[RAW].[IMP_SNOWFLAKE_ECC_PURCHASE_ORDER_SCHEDULED_LINE_DELIVERY]

[dbo].[IMP_SNOWFLAKE_ECC_PURCHASE_ORDER_SCHEDULED_LINE_DELIVERY]

3) Stored procedure :

[dbo].[SPROC_99_99_66_IMP_SNOWFLAKE_ECC_PURCHASE_ORDER]

4)Prepared job script for the above script and sent to vinay to deploy in dev

below two jobs added the job step 

[OSCAR Daily Refresh 8 AM]

[OSCAR SNOWFLAKE Daily Refresh]