Help needed for a script

Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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  
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:
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
Can anyone tell me what this would do in an .sh script @@ -912,10 +912,12 @@ Please use CODE tags as required by forum rules!... Shell Programming and Scripting
3
Shell Programming and Scripting
help in script needed
pandeesh
Hi, I am developing a script for writing out the failed jobs in file, 1)First step i need to create an empty file Status with today's date. 2)After that i need to execute the below command: dsjob -server servername -user uname -password pwd -ljobs projectname This will listout all...... UNIX for Dummies Questions & Answers
5
UNIX for Dummies Questions & Answers
Expect script help needed- script failing if router unavailable
mrkz1974
Hey all. Sometimes I'm tasked to change some router configs for the entire network (over 3,000 Cisco routers). Most of the time its a global config parameter so its done with a loop and an IP list as its the same configuration change for all routers. This is working OK. However, sometimes an...... Shell Programming and Scripting
3
Shell Programming and Scripting
script needed
revenna
hi i am new to linux world please help me,i have two files in diff location i need to compare both and i need to see difference b/w them ex /media/txt (file1) xxxxxx xxxxxx xxxxx xxxxxx xxxxxx /media/rev/ (file2) rev is a folder which contains some files so i need to compare the files in...... UNIX and Linux Applications
3
UNIX and Linux Applications
help needed! my first script
fcbarcelona1984
Create a file with x amount of lines in it, the content of your choice. Write a script named 'firstline' that takes two arguments. The first being a line of text, the second being your newly created file. The script should take the first argument and insert it into the very top (the first line)...... Shell Programming and Scripting
1
Shell Programming and Scripting