Details
-
Task
-
Resolution: Completed
-
Medium
-
None
-
None
-
IO Sprint 138
-
GxP
-
A
Description
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]
qTest: Test Execution
Attachments
Issue Links
- has to be done before
-
OS-19316 Historical KFs Logic from Bharath for LNP based on E2E tables from Bharath
- Closed