Help needed for a script

ETC Homework & Coursework Questions
1

TAG flow Between SDR and DELTA

  1. SDR is the Source table.
  2. Delta is the target table having one staging table and one Main table.
  3. Tags flows between SDR and Delta through ER gateway.
  4. From SDR (SDR.CUSTOMER_PRODUCT and SDR.CUSTOMER_PRODUCT_RELATIONSHIP) the Tags flows to ER (SERVICE_ER_SCHEMA.CUSTOMER_PRODUCT and SERVICE_ER_SCHEMA.CUSTOMER_PRODUCT_RELATIONSHIP)
  5. From ER the Tags flows to Delta staging table (dellcnt.ISP_CUST_PROD_MFG_STG_TBL) and Then from Staging to main table(s_asset).

Issues: -

  1. Tags may not move in between ER to Delta staging table
    And
  2. Delta staging table to Delta main table.

At that time, we need to know exactly where the Tag is present. So, we can treat the Tags as external parameter for the script to take input and find out where the Tag is present.

2

Hi patitapaban,

Please provide the following:

  • sample data of the various tables
  • sample data of the desired output
  • information about the platform(os, version, desired scripting language)
  • information about your tries to solve the problem so far and the questions/problems you have
  • please use
    ~~~
    text ...
    ~~~
    tags for all data
1 Like
3

I will share the details soon