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

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.