Wednesday, February 14, 2018

Importance of Data aggregation in BI

Why do I always have to select aggregation method while adding measure in BI

This is the question many people have while working with BI tools like Qliksense, Tableau, Power BI, etc.. the reason is following.

Say we have a table like following.

Number of immigrant for different countries to Canada

Year  India      China  Australia
2006 30000     5000     300
2007 32000     8000     600

(Above data is not in clean format)

Correct format is 

Year    Country    Immigrants
2006    India        30000
2006    China       5000
2006    Australia   300
2007    India         32000
2007    China        8000
2007    Australia   600








Thursday, February 8, 2018

Transferring Large files using Mendelson AS2

Mendelson AS2 heap size increase


People are always worrried about what is the maximum file size they can transfer using AS2 protocol. Technically AS2 tranfer size limit is determined by the heap size allocated for the AS2 server.

In order to increase heap memory size for Mendelson As2, perform following steps

  1. Open mendelson_as2_start.sh in the as2 home folder using any of the editors
    1. vi mendelson_as2_start.sh
  2. Go to the end of the file where you will find some thing similar to below
    1. java -Xmx1024M -Xms92M -classpath $CLASSPATH de.mendelson.comm.as2.AS2 $1 $2 $3 $4 $5 $6 $7 $8 $9
  3. Update -Xmx1024(Max memory allocated to that particular java program) to whatever size your application might need. 

Tuesday, January 30, 2018

Nobody reads

I am 99.99% sure that nobody reads this blog.

The only reason I am writing this blog now is

:: Let the Habit of writing START ::


Good or Bad, Right or Wrong start putting your thoughts in black and white. It might not make sense now but after some time you look back and read the stuff which you have written it will help you revisitig yourself back to the time, when you have written it.

I know there will be hundreds of mistakes in this blog, as I am not even reading it second time after writing it.

But who cares, the main intent is to get writing skill of mine to be out. This is the beauty about me I can write more words once I am in that mood. I think this is the most important trait to be a writer.

Today my goal is to complete at least 500 words blog, I don't know whether I can achieve it or not.
But I will certainly try. These 500 words are spontaneous and I am typing them as it is coming out of my brain.

:: Hurray.. I have started writing a blog ::


I am really happy that I have finished first section of my blog. I believe I am doing better than of news reporters who will explain same shit in different words until they fill the column. 

I wish this habit of writing will never stop and I am able to write my heart off. I will use my blogs to experiment with words, like creating new words which are not in dictionary but still those words makes sense. 

I prefer small paragraphs, I don't know how this will look in the webpage, let me check the preview of this blog.

Hurray.. It is really looking nice, I have almost written a blog which is scrollable.


:: Whats Next for Naresh ::

Who knows.. But I want Naresh not to stop writing.

The big complaint about Naresh is he will start many good things but he will not see the end. This has to change. Need to finish the things that I have started. For this i have to do following things.

  1. Don't be lazy 
  2. Don't worry whether you have mood to start contributing to the work you have started. Start contributing, mood will automatically comes.
  3. Plan your day
  4. Plan your life
  5. Don't get bored for doing repetitive stuff, 
  6. Give same importance to the smallest things in your goal, I will lose interest while doing the small things.

:: Lets count the words ::

when previewed, blog is really looking big. Let me count the words in the blog now

438 Words... 

I never thought a blog which is less than 1000 words makes any sense, but still my 438 words blog is looking decently long and I thought I have covered what I intended to cover. 

I need twenty five more words to finish my first 500 line blog. I could finish this blog by explaining how many more I need but Instead i will finish with my actual feeling.

I am feeling really accomplished for finishing the blog which I have started 10 mins before with 500 words.

:: Next Blog.. Will be on Blockchain Technology ::