Venkat$ echo

I actually love this feature in DataStage. I think this is one of the excellent feature of dataStage and yet not been effective used by everyone. So I thought let me document it. Things covered in this Blogs are RPC features and highlights Manipulating just few column from the list of RPC'd columns. Deleting a column from the RPC list as it is not required for the target. Add new columns at the bottom of the existing RPC list. RPC highlights As you all know, when we enable the check box "Runtime column propagation" there is no need to define any column definition. The column name, type, nullable characteristics and the value gets carried to the target stage.  Saves a lot of time in manual column defining ( using "load" table definition manually is not that great). Secondly when you make changes to you tables, you don't have to do anything on your DS job ( you can also argue this as a negative thing, but in most case I think it is helpful)...

Here is my first Attempt to a VISUAL CV. I thought why not use TABLEAU to achieve this. I also gave a challenge to myself to have different data source( i,e excel sheets) and join them to achieve what I want. My main objective of this exercise are - Achieve a VISUAL and INTERACTIVE CV. Use TABLEAU's new "story board" feature and hight areas of the chats based on the story selected. Is to gain a better understanding of joins with multiple data sources within TABLEAU. Visual / Interactive CV in TABLEAU URL -  https://public.tableausoftware.com/views/CV_11/CareerStory?:embed=y&:display_count=no Learn About Tableau

       DESCRIPTION of the APP Its a SINGLE PLAYER game in which the App randomly selects a 4 character english word and hides that from you. You now get 10 guesses to find that word. After each Guess the App gives you a hint of how close you are to the hidden word. The hint is given as count of BULLs and COWs. A BULL means a character in your guess exists in the hidden word and also the position matches. A COW means a character in your guess exists on the hidden word, but the position does not match. This is a simple game which can help in improving your analytical skills, memory skills and basic english. Above all its lots of fun to play this game. Examples Lets assumes "PART" is the hidden word if the guess word is "JOLT" then its 1 BULL because "T" from JOLT also exists in PART and it in the same position ie 4th position. If the guess word is "TONE" then its 1 COW because "T" from TONE exists in PART but their positi...

This is my very first IOS app, more like my first hello world app I wrote 3 years ago. DESCRIPTION of the APP 1. This app helps to spell some of the common names/words, over the phone. 2. Supports 2 languages( english and German). 3. To spell each letters, the APP uses a set of phonetic words, which have a distinctive pronunciation and   commonly used for spelling alphabet. 4. This App ships with the initial set of Phonetic words for both the languages. 5. This App also allows to customise the words, if the user prefers to have his/her own words for a specific( or all) letter(s). Technical Details: Uses Sqllite as the internal DB. Objective C Designed for iPhone and Ipods.

This blog will cover the following items Read a SharePoint document Lists (in my case it is a document library and has custom columns)  And get a handle to each file available ( which can be used to import the data from the file) Use CAMLQuery specific files only. Update value back to Sharepoint file record.  the SSIS- sharepoint  adapater from CodePlex – ( SharePointListAdaptersSetup.msi ) - https://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 Create a new SSIS Project and create a new “data flow Task” in “control Flow” screen a nd go to the “Data Flow” screen.   In “Data flow” screen you should see the below components. If not then something has gone wrong at step-1. Please fix that first. Also add the "SharePointList source" and SharePointList Destination" to the Data Flow Create a new "connection", by right clicking on "Connection Manager".  Select the Connection Manager for Sharepoint.  Now open the pro...

PIP is not prepackaged with Python 2.7 and I found that PIP is very helpful to install lots of python modules. So thought why not document the steps to install it. So here it is. Install pip - Straight Forward way  Download the get-pip.py from https://pip.pypa.io/en/latest/installing.html Run this on command line - python get-pip.py If you face any problems like "unable to fetch bla bla..." it is likely that you are having a proxy issue. If so follow the below steps Install pip with Proxy config Find the proxy config- i.e IP and PORT. if you already know it, then use that OR Go to your browser and check the proxy settings ( IE= Tools->Internet Options -> connections Tab -> Lan Settings. chrome= settings-> advanced options -> under Network -> "change proxy settings"). If your setting has "automatic proxy detection" then use the below method to find it. Open command line and type - "ping wpad" and see you can fig...

I thought I will summarise all my Tableau related blog at one spot Tableau Forum http://community.tableausoftware.com/people/venkatachalam.veerabagusubramanian/content Blogger http://venkat-echo.blogspot.com.au/search/label/tableau

If you are IOS developers who is using parse, then you must know that there is a class in parse IOS library called "PFQueryTableViewController" which has got nice feature to query a parse object and display the results on IOS App's table view. But like me if dont want to access Parse object directly instead using a Cloud Code (CC) to access all your parse object then you will not be able to use the above class as it works only when accessing the parse objects directly. bummer..... I searched for a while and couldn't find any library which can work on Cloud Code, so ended up making my own Parse extension which will work for CLOUD CODE. yay..... eCT_PFCloudTableViewController   - has got the following features Pagination with "Load more" options. With or without "Search Bar" Pull to refresh. Integrated MBProgressHUD for Nice Activity Indicators. Completely customisable. Pre-requisites: Since you will be using a Cloud Code to access th...

Sometime it is important to identify if the value of the column is changed and perform a action based on it. In the parse we have an method called request.object.dirty(<column_name>) . But the only issue is that this works only on the beforeSave. But most of us want to perform an action only when we are sure that data is saved. In other word we would like to do it on "afterSave". for eg. If you want to send a email or push notification based on a status flag getting updated. We would like to do that on the "afterSave". But on "afterSave" Here is the code how to do it. Parse.Cloud.beforeSave(" ", function(request, response) { //--find the columns which got changed var arrChangedAttributes = new Array(); var vAttributes = request.object.attributes; var query = new Parse.Query(" >> id >>>" + request.object.id ); //--means it is an INSERT. This is to identify it is an INSERT or UPDATE if(!req...