Aditya Ghosh says it is a fatal mistake when professionals begin to think they are the reason for a company's success. "I am what I am today because of the team that surrounds me, I am what I am today because of IndiGo."

Complete Article : http://articles.economictimes.indiatimes.com/2012-06-03/news/31985593_1_aditya-ghosh-indigo-president-kingfisher-airlines

Term  :  Basis Point

1/100th of 1%. For example, 150 basis points = 0.015 = 1.50%

Insurance Term : Renewal Premium

Renewal Premium :

Payment due on the renewal of an insurance policy. The premium may be adjusted up or down to reflect the loss experience of the underwriting classification to which the insured belongs.

This amount to be paid on or before Renewal Date so that Policy Coverage is unaffected.

 

Term : General Ledger

General Ledger : 

The general ledger is the core of company’s financial records. These constitute the central “books” of your system, and every transaction flows through the general ledger. These records remain as a permanent track of the history of all financial transactions since day one of the life of your company.

Each General Ledger is divided into debits and credits sections. The left hand side lists debit transactions and the right hand side lists credit transactions. This gives a 'T' shape to each individual general ledger account.

Debits	Credits

A "T" account showing debits on the left and credits on the right.

Oracle 11g Analytical Function : ListAgg

Hi All,

To show single row output from multiple rows, we do Pivot operations. I learnt today the new function called as ListAgg.

The syntax is
  listagg (<column_name_to_be_concated >, 'field_separator')
WITHIN GROUP --Notes : If you are mentoning the Group By Cause
(ORDER BY (<column_name_to_be_concated > ) aliase_name
For Eg.
Input Data is
Policy No  Policy Type
12  CA
12  BA
12 AB
13 AB

Output by Grouping the records on Policy No is
12  'AB-BA-CA'
13  'AB'