Thursday, April 30, 2015
Now, As we created some tables with data, lets do some practice with basic SQLs, Try to write queries for below statements -
-- List all data from table DEPOSIT
-- List all data from table BORROW
-- List all data from table CUSTOMERS
-- List all data from table BRANCH
Sunday, April 26, 2015
Hello Guys, As we all know that SQL is "must" known for getting into DWH area, So considering this what I am trying to do here is sharing some basic SQL assignments to complete. Start with me if wanna to test your SQL knowledge :-)
First of all, we will create some tables ( Script may need to change as per DB you are using ) -
Thursday, April 23, 2015
This script will help you to unlock the all jobs, if you are a DS admin, or your datastage jobs , if a DS developer, without doing human error while executing command on Datastage server UV shell or Datastage Administrator Client.
Script is quite simple, Execute it , it will ask for Project Name and Job Name and Done if you have appropriate access on Datastage server.
May be need a modification as per your Datastage platform or if you need some fancy stuff to add on. Happy Scripting !!
Tuesday, April 07, 2015
** This script will fetch all locks currently on Datastage Server irrespective of Projects.
** We can modify this script to correct the data display format as per our need
** Can modify sort command as it changes its behavior in different Linux flavour
Monday, April 06, 2015
Guys, sorry for being away for so many days but I am back :-)
Today, I am going to share a batch script , written by KIM DUKE, hats off to him :-). Originally this script is designed for Datastage 7.5 but we can easily re-write for current versions. Please play with it and share your script if possible :-)