Help needed for a script

Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Old 06-19-2018
Help needed for a script

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.

Last edited by rbatte1; 06-19-2018 at 07:46 AM.. Reason: Formatted number lists with LIST=1 tags
# 2  
Old 06-19-2018
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 [code]...[/code] tags for all data
This User Gave Thanks to stomp For This Post:
patitapaban (06-19-2018)
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Sh script help needed samd12 Shell Programming and Scripting 3 07-15-2017 08:41 AM
Help Needed on Script itsme488 Shell Programming and Scripting 6 05-14-2013 11:01 PM
Help needed for script solaris_1977 Shell Programming and Scripting 8 12-20-2012 03:01 PM
Script needed ahmed_as8 Shell Programming and Scripting 6 04-10-2012 11:50 AM
help in script needed pandeesh UNIX for Dummies Questions & Answers 5 08-09-2011 10:00 PM
Expect script help needed- script failing if router unavailable mrkz1974 Shell Programming and Scripting 3 05-20-2011 11:27 AM
Script needed... jacki Shell Programming and Scripting 2 09-20-2010 05:58 AM
Help Needed in Sh script jkumsi Shell Programming and Scripting 1 09-17-2010 01:23 PM
Script needed... jacki Shell Programming and Scripting 1 09-08-2010 06:31 PM
help needed for a script!! rahul195 Shell Programming and Scripting 5 10-04-2009 06:15 PM
script needed revenna UNIX and Linux Applications 3 11-19-2008 05:41 AM
Script help needed Sagarddd Shell Programming and Scripting 1 11-18-2008 01:02 PM
Script needed vpandey Shell Programming and Scripting 3 03-04-2008 08:45 AM
help needed! my first script fcbarcelona1984 Shell Programming and Scripting 1 11-04-2007 11:32 AM
Script Needed Dastard Solaris 1 03-20-2007 10:54 AM